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,258 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,888 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,318 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
786 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
950 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
21,063 reads
Blogs
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers