Posts filed under: sql server

More SQL Learning – Performance, Tuning, and Troubleshooting

I recently came across a new blog by Ramesh Meyyappan on “Seek or Scan – Cost Based Optimizer in SQL Server“.  In the youtube video (17 minutes) he covers the......
Continue Reading →

Loading Data into SQL Server From Excel

Oft times trying to use the SQL SSIS Import wizard to load data into SQL server from excel you run into data type conversion errors and have to go through......
Continue Reading →

Changing the batch separator in SSMS

I can see the confused looks. “Joel what are you talking about?” We’re talking about Batches By default, in SQL Server Management Studio (SSMS), your query is submitted and executed......
Continue Reading →

SQL Server Crib Sheets

SQL Server Central has a free ebook that compiles high level crib sheets that cover a few different areas.  These give a good overview of high level concepts and tools......
Continue Reading →

Scripting Data from a table doesn’t have to be like pulling teeth

Sometimes you need to be able to script the data out of a table and it is easier than you might think. I commonly do this when I am generating......
Continue Reading →

SQL Server 2016 coming June 1st (And free stuff)

Microsoft announced the June 1st release date for SQL Server 2016.   Read to the end for other big news. From the breakdown of Features Supported for SQL 2016 by Edition......
Continue Reading →

SQL Server Discontinued Features and Items marked for deprecation

With each version of SQL server certain items are discontinued (removed) from that release, and other items are marked for deprecation (removal in a future release). Earlier this week I......
Continue Reading →

Hiding the SSRS Breadcrumbs from Users

It is common when rolling out our SSRS prototypes that different onsite users will be interacting with the different products. This means that typically different user groups will be setup and......
Continue Reading →

SSRS Error – ReportServerDatabaseUnavailableException

We recently had a customer trying to upgrade an SSRS solution and they were receiving some of the errors below. Some were from when they were trying to deploy the......
Continue Reading →

SSDT Deployment Optimization for Table Constraints and Calculated Columns

Calculated columns on tables can be helpful. For example let’s assume you have a table with Name Fields and you have a formula for FullName. You typically want that formula......
Continue Reading →