Three seemingly independent review sites are not that independent after all.
I passed CompTIA N+ and S+ with about a week of studying for each. Here are my recommendations.
The Query Store is a feature that helps you evaluating query performance. It captures execution information asl well as up to 200 plans for a single query. For a thorough overview on the Query Store you can read Enrico van de Laar’s article here. Query Store is also available for Azure since V12. To turn on Query Store […]
Let’s just say, it wasn’t a pretty piece of script.
This is a follow up to my post in May 2014 titled “If I had a restaurant…I would build the 20% service fee into the prices.” (Clicky clicky. It opens in a new window.) Obviously I wasn’t the only one to think tipping is the work of the devil. Over the past two years several restaurants […]
The title says it all, but let me expand on this a little bit. I have an assembly that I wanted to emulate in SQL server. The first, obvious choice is to use safe mode, which results in the following message: Msg 6212, Level 16, State 1, Line 2 CREATE ASSEMBLY failed because method ‘x’ […]
This blog post here on BI Developer Network contains a nice list on data conversion between SSIS and SQL server, something that gets my blood pressure going due to SSIS’s ‘check your metadata’ error message. Good cheat sheet that list the data types. SSIS Data Type SSIS Expression SQL Server single-byte signed integer (DT_I1) […]
I ran into some ‘Message 823’ issues on my development DB, and upon running DBCC CheckDB() I saw that my indexes were the ones throwing the errors. I got this handy cursor from SQL Server Performance, and decided to save it here for me, and for you, so that I don’t have to search for […]
I will make this short and sweet for you. If there is something you want to do to all tables in your database, there is a command for you. I will demonstrate, watch my hands because I cheat. To add a column to every table: exec sp_msforeachtable ‘alter table ? add intGoat int NULL’ To […]