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.
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 […]
So our aggregated databases have experienced some loading errors lately, and until that gets fixed, I have to collect the data straight from the field databases for each report. That is, go in the database, pull the data, load into temp. Go in the next database, pull the data, load into temp. Go in next, […]