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,259 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,891 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,319 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,699 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
788 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
953 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,511 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,374 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,449 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,100 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Automating OSM Data Refresh in Power BI’s Azure Maps Reference Layer
Comments posted to this topic are about the item Automating OSM Data Refresh in...
Database Mail Configuration
Comments posted to this topic are about the item Database Mail Configuration
Learn From History
Comments posted to this topic are about the item Learn From History
Question of the Day
Database Mail Configuration
If I want to get a list of the configuration settings for Database Mail using T-SQL, how can I do so?
See possible answers