Database mirroring is a great option for many disaster scenarios. If using a witness server automated failovers can be achieved. However, just like any other disaster recovery solution database mirroring should be tested. Before you execute your first test of failing over a database from one server to another you ...
SQL Server is a relational database server, developed by Microsoft: It is a software product whose primary function is to store and retrieve data as requested by other software applications.
-
-
2012 MVP Summit Preview
Next week I will be attending the 2012 Microsoft MVP Summit. This will be my third Summit but it feels like my first because there are going to be a lot of new faces there for the first time. That’s why I wanted to take the time to remind ...
-
Want Another Reason to Hate iTunes?
I’m not one to whine. Really. I’m totally not a whiner. However, I’m going to sound like one with this statement… I fricken HATE iTunes. There, I said it. I’m already starting to feel better. Playing on Elisebeth Barrett Browning and her fantastic poem, “How do ...
-
SQL Server 2012 (“Denali”): FileTable
FileTable is a new feature in SQL Server 2012 that is built on top of SQL Server FILESTREAM technology, which allows BLOB data to be stored as individual files separate from a database’s data files. Interactions with the FileStream files took place only through T-SQL or through code which ...
-
SQL SERVER – T-SQL Constructs – Declaration and Initialization – SQL in Sixty Seconds #003 – Video
We got tremendous response to our very first video of SQL in Sixty Seconds #001 and SQL in Sixty Seconds #002. We talked about how to convert Subquery to CTE and Error and Reaction. My co-authors Vinod Kumar and Rick Morelan, we often came across very interesting and useful tips ...
-
Julie Presents SSIS 2012 A Fresh Start in Columbia
Thanks for attending tonight. Here is the link to the slidedeck.
-
Using the MDX Script Debugger in BIDS
Almost every time I write MDX calculations, I end up using scoped assignments – it’s by far the easiest way to control where your calculations work inside a cube. However making sure that your scoped assignments work in the places that they’re meant to work and don’t overwrite ...
-
Support me and Team #SQLPlunge for the Special Olympics
On March 3, 2012 I will be jumping into a hole in the ice in Lake Calhoun to raise money for the Special Olympics. One item on my bucket list will be crossed off – I don’t think I want to get good at this, but I do want to ...
-
Still Using Windows Logins for your Databases? You’re Doing it Wrong
If your DBA is still adding Windows logins to your database servers then they are doing it wrong. Using logins (versus Windows groups) is an inefficient method that hasn’t been considered a favorable practice for almost ten years. Oh…sure…it works. I won’t argue that point. But ...
-
Please vote for my SQLRally session
I’m hoping to do a presentation at SQLRally in Dallas on May 10-11, but I need your help! There is a Community Vote for the remaining 20 sessions, so I would greatly appreciate it if you would go to http://www.sqlpass.org/sqlrally/2012/dallas/CommunityChoice.aspx and ...