The goal of this presentation is to get you thinking about the use of SQL Server constraints, starting with the basics of making sure the data in a single table is reasonably constrained. We'll start with data types, column lengths, and nullability...
In my T-SQL code I always use set based operations. I have been told these types of operations are what SQL Server is designed to process and it should be quicker than serial processing. I know cursors exist but I am not sure how to use them. Can you p
There are many instances when dates and times don't show up at your doorstep in the format you'd like it to be, nor does the output of a query fit the needs of the people viewing it. One option is to format the data in the application itself. Another opti
We can use regular expressions (sometimes called Regex) with T-SQL to tackle some common problems with data using this tool. In this tutorial, we will practice using regular expressions for filtering precise phrases involving alphabetic, numeric and speci
To gain insight into the evolving challenges for DBAs, a study was performed to survey DBAs and those responsible for the management of the corporate data management infrastructure. The more than 200 respondents came from a wide range of industries...
In some scenarios we can find different SQL Server collations between the server instance and its databases. Sometimes the collation is fixed in some table columns or inside stored procedures to solve some of relationship problems with columns that have
What are the steps involved in a simple upgrade to SQL Server 2014? I am currently running an older version of SQL Server and want to do an in place upgrade. In this tip we do a walk through of the installation process.
One of the relatively new functions for Analysis Services Tabular, Power Pivot and Power BI is TREATAS. In this tip, we’ll introduce you to the syntax and concepts of the function and show some uses cases where this function can be useful.