Scripting schema AND data with SSMS in SQL 2008
It's very commonly known that you can use the Script Wizard in Management Studio to script out tables or even an entire database. It's NOT
It's very commonly known that you can use the Script Wizard in Management Studio to script out tables or even an entire database. It's NOT
In this week's survey I'd like to know how often you run consistency checks on your *most critical* production database, regardless of *how* you run
In last week's survey I asked how you manage the size of your database *data* files – see here for the survey. Here are the
This afternoon we headed down to Lake Storey in Galesburg, IL to chill out and get some sun. While the kid's were splashing about in
(New for 2020: we’ve published a range of SQL Server interview candidate screening assessments with our partner Kandio, so you can avoid hiring an ‘expert’ who
I came across a question on ServerFault this afternoon that inflamed my desire to be ultra-geeky (it was really already inflamed after teaching backup and
It's lunchtime for my class – time for a blog post! This is an interesting one that crops up every so often (just an hour
A couple of weeks ago while Kimberly was in Mountain View at the same client I'm at, our good friend Richard Campbell sent me email
In this week's survey I'd like to know how you manage the sizes of your database *data* files (remember we've already done log file size
In last week's survey I asked you what you think is the hardest thing when becoming an involuntary DBA – see here for the survey.
There are a couple of issues that I’ve heard of in the last few weeks (one while onsite at a customer) and I think they might bite
On Friday we had a planned spare day in Houston after spending the week onsite with a client. It was the 3-year anniversary of our
We're onsite with a great client down here in (very hot) Houston and Kimberly's lecturing right now so I'm digging around finding some info on problems
This week's survey is all about being a DBA or involuntary DBA – what do you think is the hardest thing when becoming an involuntary
In last week's survey I asked what you think is the most important thing when it comes to performance tuning, if you *had* to choose
The July 2009 edition of TechNet Magazine is available on the web and include a feature article I wrote explaining backups. It's the first in
There's another DBA 'chain-blog' going around, this time started by Tim Ford, and I was tagged by Tom LaRock. The idea is that you're stuck
Just found this excellent blog post (continually updated) that lists a ton of free SQL Server tools for all sorts of purposes. Check it out
Wow. This is a driving stunts video by Ken Block – it's just jaw-dropping what this guy can do flying around a dockyard in a
Chad Miller over on SQLServerCentral has put together a really great collection of scripts that allow you to easily monitor and report on what backups
Part of being a Microsoft Regional Director is getting early access to information and private releases to play with. They also hand out free stuff
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.