Patching Master Data Services
I recently installed my first deployment of Master Data Services (MDS). I installed the SQL Server 2014 (Enterprise Edition) MDS...
2015-04-13
842 reads
Exam Prep 70-463: Installing Master Data Services
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2015-04-21 (first published: 2015-04-13)
5,502 reads
Azure SQL Database Firewall Settings
The new portal for managing Azure is pretty. I’m not sure I’m in love with it, but it’s pretty.
However, one...
2015-04-24 (first published: 2015-04-13)
5,256 reads
In-Memory OLTP: Part 2 – Indexes
Following on from In-Memory OLTP: Part 1 – Introduction where we created a database capable of hosting memory optimised tables, I’d...
2015-04-13
482 reads
In-Memory OLTP: Part 2 – Indexes
Following on from In-Memory OLTP: Part 1 – Introduction where we created a database capable of hosting memory optimised tables, I’d...
2015-04-13
882 reads
How to Test Existing T-SQL Code Before Changing the Compatibility Level
You can easily determine whether existing stored procedures, UDFs and views can work in a higher (or lower, if you wish) compatibility...
2015-04-13
5,002 reads
Designing for offloaded log backups in AlwaysOn Availability Groups – Part 2 – Monitoring
AlwaysOn Availability Groups have made a big splash in the SQL world and are quickly becoming the HA and DR technology of choice for many SQL Server environments. Crucial...
2015-04-13
8 reads
Designing for offloaded log backups in AlwaysOn Availability Groups – Part 2 – Monitoring
AlwaysOn Availability Groups have made a big splash in the SQL world and are quickly becoming the HA and DR...
2015-04-13
1,139 reads
Handling Mixed Format Data Files in SSIS
Some time back I wrote about how to use the script component to parse out ragged data files in SSIS....
2015-04-22 (first published: 2015-04-13)
6,013 reads
How to restore Master database – SQL Server System Database?
Steps to restore SQL Server Master Database :- 1) Stop SQL Server Services 2) Add [-m] startup parameter in SQL Services from configuration manager Parameter [-m] Starts SQL Server...
2015-04-13
20 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers