Browse the archive
WARNING: Silent truncation ahead Have you ever tried to enter a really long description on a SQL Agent job? Maybe you were trying to put some sort of warning to people who might be trying to edit the job, or triage info for when the job fails. (Ok, so this …
Continue readingWho ya gonna call? If there's somethin' strange in your neighborhood Who ya gonna call? If it's something weird and it won't look good Who ya gonna call? This summer, they've been taping the new Ghostbusters movie in Boston. It's pretty cool to see the …
Continue readingThis evening, I did my first presentation at a user group at my local user group. Sure, it was just a lightning talk, but the New England SQL Server user group is a tough crowd. People ask tough questions. Nobody is timid about interrupting you to ask their …
Continue readingQuestion Imagine we have two nodes participating in SQL 2012 AO. This is a test instance. During one of the index rebuild operation the log was grown up really big (250 GB). We are unable to back it up due to space constraint. What if we backup the Tlog to …
Continue readingUse SQL Server Agent multiserver administration to manage jobs across availability group replicas.
Continue readingWhat is the service account running your instance of SQL Server? A lot of DBAs probably know right off the top of their head–maybe because they’re using the same account for every instance. Have you ever had to audit every service account on every instance? If …
Continue readingAaron Bertrand (twitter|blog) recently blogged asking for help to fix a big security loophole. I read the post then, but it was only this morning that I finally got around to REALLY looking at it, thinking about it, and testing it out for myself. Aaron can do …
Continue readingThis is a pretty common problem. I think it’s a question every developer has asked at one time or another: “I want to pass in a comma-separated list of values, then convert it into a table." Every company I’ve ever worked for has had a function that does this. …
Continue readingQuestion I am trying to restore a .bak file (backup taken on SQL Server 2008 R2, compatibility level 100). I am restoring the backup on SQL Server 2012 edition. I get the below error. Unfortunately the original DB from where the DB was backed up is no longer …
Continue readingOne of my coworkers asked me about output parameters from dynamic SQL today. I pointed him at sp_executesql, which allows for passing parameters into or out of dynamic SQL. The syntax can be confusing at first blush (especially for a new DBA or developer), but …
Continue reading
