DBCC CheckTable, Spatial Indexes and incorrect compatibility mode…..
Just a very quick blog today regarding an issue that has arisen with one of my clients. During Integration it...
2012-11-19
1,257 reads
Chris's SQL Blog
Developing Microsoft SQL Server 2012 Databases (70-464) – My Thoughts
I finally pulled my finger out and took the last exam of the MCSE SQL Server 2012 – Data Platform certification...
2012-10-30
6,879 reads
Implementing a Data Warehouse with Microsoft SQL Server 2012 exam (70-463) – My Thoughts
Well I finally got around to completing the MCSA aspect of the SQL Server 2012 Certification and I’m pleased to...
2012-09-13
1,309 reads
SSIS SCD vs MERGE Statement – Performance Comparison
I wouldn’t class myself as an expert in SSIS but I certainly know my way around but came across something...
2012-07-03
8,695 reads
It’s that time of year…..Exceptional DBA Awards 2012
Being a 2011 finalist I felt I should try and rally all those who truly are exceptional to get their...
2012-06-25
784 reads
And the results are in…..SQL Server 2012 beta exams
Well after being a bit late in trying to book the beta exams I managed to get three of the...
2012-06-25
941 reads
Querying Microsoft SQL Server 2012 Beta exam (70-461 / 71-461) – My Thoughts
Well I’ve now done the final SQL Server 2012 exam I managed to get a slot booked for. The Querying...
2012-04-13
3,508 reads
Designing Database Solutions for Microsoft SQL Server 2012 Beta exam (70-465 / 71-465) – My Thoughts
After sitting the Administering Microsoft SQL Server 2012 Databases Beta exam (71-462) on Monday, I was still a little disappointed...
2012-04-06
1,369 reads
Administering Microsoft SQL Server 2012 Databases Beta (70-462 / 71-462) – My Thoughts…
On Monday I did my first Microsoft SQL Server exam since I did my SQL Server 2000 exams many moons...
2012-04-04
1,446 reads
How to output from invoke-sqlcmd to Powershell variable
Sorry for another Powershell post but I’ve been doing a lot of it recently and coming up with (what i...
2012-02-03
20,928 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers