|
|
-
|
|
The second draft of the free Introducing Microsoft SQL Server 2012 eBook will be released on 1st February 2012 and will contain the following chapters: PART I Database Administration 2. High Availability and Disaster Recovery Enhancements 3. Scalability and Performance 4. Security Enha......
|
|
-
|
|
Thanks to Paras Doshi for providing details on the following article relating to troubleshooting SQL Azure connection issues. Larry Franks has put together a TechNet Wiki article on SQL Azure Connectivity Troubleshooting which covers: 1. Common Connectivity Errors 2. Verify SQL Server Manageme......
|
|
-
|
|
For those of us who spend time on the SQL Server Forums, you’ll probably agree that one of the most common calls for assistance relates to troubleshooting SQL Server connections. This is why Rick Byham’s TechNet Wiki article on “How to Troubleshoot Connecting to the SQL Server Database Engine” is a ......
|
|
-
|
|
The Microsoft Virtual Academy (MVA) is a free cloud-based learning environment focusing on Microsoft Technologies (Although the site states that it focuses on cloud-based technologies, I have found content in some countries not specific to the cloud). The concept behind the MVA is similar to that o......
|
|
-
|
|
The following SQL Server exams are due to retire on 31 July 2012: Exam 70-453 - Upgrade: Transition Your MCITP SQL Server 2005 DBA to MCITP SQL Server 2008 Exam 70-454 - Upgrade: Transition Your MCITP SQL Server 2005 DBD to MCITP SQL Server 2008 DBD Exam 70-455 - Upgrade: Transition Your......
|
|
-
|
|
Just sharing a cool script I stumbled across while searching for SQL Server index fragmentation scripts (Omer van Kloeten's Blog). I’ve cleaned it up a bit and turned it into a Stored Procedure so that I can execute it as a SQL Server Agent Job (Not sure if this is a good idea or not so feel f......
|
|
-
|
|
This experimental online service provides the ability for users to analyse their SQL Server databases to see whether they’re compatible with SQL Azure. The service provides the user with a report listing the database objects not supported on SQL Azure, and the objects that need fixing. <a href="......
|
|
-
|
|
There’s been an update to the SQL Server 2012 Developers Training Kit (November 2011). This training kit is a great resource for developers, trainers, consultants and evangelists who need to understand SQL Server 2012 and SQL Azure improvements from a developer perspective. It contains a rich set o......
|
|
-
|
|
Microsoft is teaming with PASS to bring you the SQL Server 2012 Special Ops Tour, a cross-country, technical training roadshow that will take them to 12 cities across America. Help shape the course of action for this tour by completing this Survey. Wonder if Microsoft Australia will do something si......
|
|
-
|
|
While finalising some slides for my presentation at the Canberra .Net User Group on Using XML and TVP’s to Transport Relational Data, I stumbled across a couple of posts by Bob Beauchemin relating to how TVP’s cause plan recompiles when called from ADO.NET. Given that I published a post back in May ......
|
|