Pro Members

Pro Members SQL Server Standard Members

Database Capacity Planning

Database Capacity Planning By Craig S. Mullins Most database implementations are anything but static. Once deployed, databases are queried, updated, loaded, unloaded, reorganized, and data is deleted and inserted from them on an ongoing basis. As the data composition of a database changes, it storage requirements will change as well. The DBA must be ever vigilant to plan for future…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members Standard Members XML

XML Support and SQL Server (Part 3)

XML Support and SQL Server (Part 3) By Basit A. Farooq This article is the third part of the XML support and SQL Server article series. In this part, I’ll first talk about what fundamental problems we have in integration XML and SQL Server. Then, I’ll cover what storage options we have in SQL Server to store the XML data…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Development Pro Members Standard Members

Working with PEX Framework

Working with PEX Framework Microsoft’s PEX Framework is an automated white box testing tool that can be integrated with Visual Studio. It has been developed by Microsoft research team and generates test suites with high code coverage. It can investigate and explore the managed code and suggest the tests which a particular test requires. PEX framework from Microsoft provides support…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

SQL Server 2012 XML Optimization Tips

SQL Server 2012 XML Optimization Tips Consider using the XML data type. This data type is used to store XML documents in table columns or Transact-SQL variables. The XML data type can be used in variables, columns, or in stored procedure and function parameters. You can build, rebuild or drop XML indexes online. In SQL Server 2012, indexes that include…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Learning SSAS: Part III- Building Cubes

Learning SSAS: Part III- Building Cubes Hello and welcome to the third part of this series dedicated to learning SQL Server Analysis Services. In the first article I talked about the basics of dimensional modeling and business intelligence. Also, the reader was acquainted with the jargon associated with data warehousing. In the second article the reader learnt few things about…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Recoverability Trumps Performance

Recoverability Trumps Performance By Craig Mullins Many DBAs reading this article will look at the title and immediately think I’m wrong… at least initially. They’ll claim that managing performance is the most important thing they do, but they are confusing frequency with importance. Yes, DBAs confront performance issues more often than they build backup plans – and they better be…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Development Pro Members Standard Members

Working with Parallel LINQ

This article reflects on parallel programming concepts, PLINQ, discusses the new features and enhancement to the Parallel Extensions Library, and reflects on how to implement declarative data parallelism in your applications using PLINQ. It also discusses the tips and techniques to better leverage the benefits of PLINQ. Single and Multi-threaded Applications Applications are either single threaded or multi-threaded. In a…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Tips for using SQL Server 2012 backup and restore

Tips for using SQL Server 2012 backup and restore Consider using page restores. SQL Server Management Studio supports page restores in SQL Server 2012. Now you can check database pages for corruption and restore selected corrupt pages from a database backup and subsequent log backups. Use the Database Recovery Advisor to construct restore plans that implement optimal correct restore sequences…....

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Learning SSAS-Part II: Data sources, Data source views

Learning SSAS-Part II: Data Sources, Data Source Views Welcome to the second part of the Learning SQL Server Analysis Services series. In the first article of the series you learnt the basics of business intelligence and data warehousing. You also understood about various terms like cube, dimension and facts. Now it is time to use this understanding and apply it…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
DB2 Pro Members Standard Members

DB2 SQL: Stages 3 and 4

DB2 SQL: Stages 3 and 4 By Craig S. Mullins All good DB2 developers and DBAs know about Stage 1 and Stage 2 predicates, right? But have you ever heard of Stage 3 and Stage 4 predicates? Well, you’re about to! First of all, let’s do a quick review to catch those readers who don’t know what Stage 1 and…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register