Service pack Native Client, SQL XML4 and VSSWriter failed
One of my client accidentally executed a 32 bit service pack on a 64 bit SQL Server, the service Pack...
2012-08-09
1,545 reads
Blog Posts
SQL Server : Implementation of Table Valued Parameter (TVP)
Some time there will be situation in application , where a
grid is populated with data and user has option to edit...
2012-08-09 (first published: 2012-08-01)
6,339 reads
SQLSaturday 159 - KC Can Sure Throw a SQL Saturday!
This past weekend was SQLSaturday159 - Kansas City. I drove down with my wife and our sons (2 years old and...
2012-08-09
953 reads
Using a Dedicated Administrator Connection (DAC) on SQL Server
Dedicated Administrator Connection (DAC) allows administrators emergency access to SQL Server via SQL Server Management Studio (SSMS) or via command...
2012-08-09
1,492 reads
Working With Compliance
Most larger and all publicly held companies will have some sort of compliance team – often a few varieties, ranging from...
2012-08-09
577 reads
Cost Savings and Backup Compression
Let me set the scene, one of our internal IT SQL Servers which stores a whole host of performance metrics...
2012-08-08
1,845 reads
How many SQL Servers you run within your environment ? – MAP could be your best bet to answer this question !
A blog post about Microsoft Assessment Planning Toolkit was in my list for quite a while and today I decided to write...
2012-08-08
918 reads
How to Data Compress Varchar(MAX)
I talk a lot about compression. I’ve blogged a pretty decent amount on it as well. One of the things...
2012-08-08
8,021 reads
More Suggestions for SQLSaturday Admin Tools
I just finished the draft schedule for SQLSaturday #151 in Orlando and wanted to write some notes about the process....
2012-08-08
465 reads
SQLSaturday #160, Kalamazoo
Date: September 22, 2012
Title: So I started this blog…now what?
Abstract:
Ever thought about trying your hand at blogging? Or maybe you’ve...
2012-08-08
598 reads
Blogs
Monday Monitor Tips: The MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, and pressing on...
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Forums
Removing production permissions when restoring database to non-prod
Hello experts, An application team has asked us to modify a SQL Agent job....
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...
Finding Bad Queries
Comments posted to this topic are about the item Finding Bad Queries