Latest Blog Posts
It always amazes me how fast these T-SQL Tuesday block parties come about; it seems like we just finished one and here we are yet again. This month the party is hosted by Tracy McKibben (Blog | Twitter) and the monthly topic that was chosen is “Heroes”.
This… Read more
This Wednesday we’re having a special joint meeting of oPASS and MagicPASS featuring Microsoft GM Mark Souza. For the past couple months we’ve referred to it internally as “Operation Souza” as we discussed how to best support his visit and do the most for our local SQL community. We contacted… Read more
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (
so exciting), follow me on twitter (@StrateSQL). And see these throughout the day as I tweet out links of things I find interesting. While these links aren’t the answer… Read more
- Not a bad drive over from Orlando. Only a little traffic, about 80 minutes.
- I was early enough to have time to review my presentation and then work on the final marketing notes for SQLSaturday Orlando (good to have a few tasks queued when time appears)
- I stopped at Starbucks…
Subscriptions are a great feature in Reporting Services that will run a report unattended and deliver it to users either by email or Windows File Share. Subscriptions can also be scheduled so if your end users need a report monthly you can automate the delivery process. The steps given in… Read more
Coming soon is the SQL Saturday #332 in Minneapolis, MN on October 25th, with my preconference training session on Friday, October 24. I am really looking forward to attending these events!
Virtualization for SQL Server DBAs Precon
I can’t believe this will be the fourth SQL in the City in London next week. It’s amazing to me that we’ve managed to build this great series of one day events that is so popular with SQL Server professionals.
I’m heading back to London next week, a quick trip,… Read more
1) Take Full backup of database at Principle Server
BACKUP DATABASE USERDB1 TO DISK = ‘H:USERDB1.BAK’
2) Take Log Backup at Principle Server
BACKUP LOG USERDB1 TO DISK = ‘H:USERDB1_LOG.TRN’
3) Copy both backup files to Mirror server
4) Restore Full backup with No Recovery at Mirror Server
USE [master] Read more
Mssqltips.com:- I like this site because I find here…
I love negative feedback. Well, not really. I love constructive feedback. I love the feedback that gives me things to think about. Am I presenting the right material? Am I presenting it in the right way? Can I improve? But, in order to get constructive feedback, people have to tell… Read more
If a user is a member of Sysadmin server role of SQL Server 2005, the user runs xp_cmd_shell in the security context of SQL Server service running account. If he is not a member of sysadmin role, the server proxy account must be setup,…
Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time to dig out some old posts and find out if there are any undiscovered finds there. In this post, I’m bringing up some of my old posts to… Read more
After finishing up six months of managing the marketing for SQLSaturday Orlando I’ve been going back through all my blog posts to outline stuff we (or any other event) can use next year. It’s not a complete project plan, but I hope it gives you some ideas and a… Read more
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.
Posts That Were Popular This Week
- Invite for #TSQL2sday #59 – My Hero!
- Using Encryption To Protect Your Data From Alien Abduction
- Building (for…
Temporary Post Used For Theme Detection (919ceef8-1031-4873-93f5-7a833585812f – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
This is a temporary post that was not deleted. Please delete this manually. (e5bad5db-3b7d-4641-ba91-15ab900e8f70 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
I have had a fairly busy travel schedule the last few years. While I don’t love sitting on airplanes and being away from home, I do look forward to the events and seeing the amazing #SQLFamily and community we have for SQL Server. I’ve also learned a few tricks to… Read more
I saw a whole bunch of great sessions last month. I was all over the place from Las Vegas to San Diego and then Antwerp and Utrecht at Connections, two different SQL Saturday events and SQL Server Days. The speakers just seem to keep getting better, making this more difficult.… Read more
Today I presented the final ramp up session entitled “Virtualization for SQL Server DBAs 499” for the SQL PASS Virtualization Virtual Chapter. It’s the last session in a four-part where the goal is to take the DBA from knowing nothing about infrastructure and virtualization technologies up to… Read more