One of your five a day
When using the new SQL Server Integration Services (SSIS) catalog we can deploy our solutions using the UI or build a T-SQL script to deploy it creating folders on the way for a repeatable successful deployment package.Firstly we set the database,
I was talking to some of my clients and colleagues recently about the Free SQL Server Training and enthusing about the community experience and free training available. Although the paid training has its place in learning its important to combine this with
In an earlier post we looked in the United Kingdom and how we might use postcodes together with the geography data type in SQL Server 2012.Now as our next step we will optimise our query to make use of the
After setting up a new Availability group and leaving its settings as the defaults, “Prefer Secondary” for Backup and Readable Secondary to “No”, Data Protection Manager cannot complete a successful consistency check.Simply setting the Readable Secondary to “Yes” for all
Sometimes we’ll want to hide lots items from the tile view in Reporting Services. There’s no quick way to, for example, hide all your sub reports view the user interface. As long as you’ve got a standardised naming convention, such as prefixing
I’ve been looking forward to using some of the features of spatial data in SQL Server 2012 but realised I hadn’t found a quick way to utilise UK Maps. Since it’s highly graphical and tangible in nature I believe this
Now we have our AlwaysOn solution and the same SQL Agent jobs running on each availability replica and they reference the availability group listener. So we’re all set up and running with our Availability solution but our SQL Agent jobs are unaware
I attended the pre-con day at SQL Scotland in Edinburgh with Jonathan Kehayias and Joseph Sack from SQLSkills. It was exceptional! It was a very quick day, which is usually a very good thing. I also came away with a
I’d been looking for a simple alert to run in SQL Agent to notify me of failover and alert number’s 41074 and 35266 seem to work reliably if you just need to know you’ve failed over. Also using some of
SQL Server Service Pack 1 is available from http://www.microsoft.com/en-gb/download/details.aspx?id=35575 including slipstream options.