SQL Server

SQL Server Community

SQL Server Blogs

Follow /22 May 2015 at 2:30pm / SQL Server

004 – Cracked Foundation - WaterOx Consulting

Reading Time: 4 minutes Do You Have a Cracked Foundation? in WOxPod!, episode # 004 –... The post 004 – Cracked Foundation appeared first on WaterOx Consulting .
70 0 /
Dinesh Asanka
Follow /22 May 2015 at 5:56am / SQL Server

MSSQL Server 2016 coming with JSON Support

With over a thousand votes on the Microsoft Connect site, JSON support is the most requested feature for SQL Server 2016. This month, Microsoft announced that the upcoming release of SQL Server 2016 will fulfill that request. Sort of. Microsoft will certainly...
83 0 /
Follow /21 May 2015 at 1:00pm / SQL Server

What is the Difference between a Primary Key and a Foreign Key?

In this article we learn the difference between primary and foreign keys, and why both are important to maintaining a relational database structure. All the examples for this lesson are based on Microsoft SQL Server Management Studio and the AdventureWorks2012...
151 0 /
Gethyn Ellis
Follow /21 May 2015 at 1:00pm / SQL Server

Creating an Azure SQL Database

By David Postlethwaite Once you have logged in to the Azure Management Portal you can start to create an Azure SQL Database. Azure SQL Database is an example of Platform as a Service (PaaS), we don’t have to build a Windows server or install the SQL software...
98 0 /
Follow /21 May 2015 at 10:25am / SQL Server

Behaviour change for delete … output … into in SQL Server 2014

A colleague of mine discovered an interesting behaviour change from SQL Server 2012 to SQL Server 2014. We recently upgraded one of our servers from SQL 2012 to SQL 2014 and a job started failing. (Although I haven’t explicitly tested this behaviour...
99 0 /
Ed Elliott
Follow /20 May 2015 at 7:00pm / SQL Server

MergUi 0.1.9

What is MergeUi? A Visual Studio Addin to create and edit MERGE statements in SSDT projects. What have you done? I have released a new version of MergeUi, thanks to Luca Zavarella for prodding me into getting this release out and for pointing...
107 0 /
Ed Elliott
Follow /20 May 2015 at 5:41pm / SQL Server

Putting the ORM debate to bed

Hopefully this should put the ORM debate to bed, either use an ORM or don't but please don't access tables directly... There are obviously reasons behind all of this but if you follow this golden rule you will have a happy DBA and user base...
115 0 /
Jen McCown
Follow /20 May 2015 at 5:12pm / SQL Server

Coming soon: Minion Backup, featuring table based scheduling!

The MidnightDBA team is announcing the release of a new, free backup solution for SQL Server: Minion Backup arrives on June 1! Minion Backup by MidnightDBA is a stand-alone database backup module.  Once installed, Minion Backup automatically backs up...
118 0 /
James Serra
Follow /20 May 2015 at 4:00pm / SQL Server

SQL Server 2016 public preview arriving this summer

SQL Server 2016 was recently announced.  Top new features include: Always Encrypted protects data at rest and in motion.  With Always Encrypted, SQL Server can perform operations on encrypted data and best of all, the encryption key resides with the...
118 0 /
Follow /20 May 2015 at 3:30pm / SQL Server

SQL F.A.D. – Daily Identity Reset - WaterOx Consulting

Reading Time: 3 minutes Sometimes you have to do some things considered pretty strange in your... The post SQL F.A.D. – Daily Identity Reset appeared first on WaterOx Consulting .
103 0 /
Derik Hammer
Follow /20 May 2015 at 2:05pm / SQL Server

QS-Config v2.0 Enters Open Beta: Major Refactoring

QS-Config v2.0 has passed closed beta and is now entering open beta . Feature changes / additions: Supports PowerShell v2.0 and higher. Supports SQL Server 2014. One script for all supported versions of SQL Server, rather than a script per version...
102 0 /
Michael J. Swart
Follow /20 May 2015 at 1:00pm / SQL Server

It’s Hard To Destroy Data

It is surprisingly difficult to delete data permanently. SQL Server has sophisticated features that prevent all kinds of data loss, but the opposite is not true. SQL Server has very few features that help you destroy data. But why would anyone need...
127 0 /
Kenneth Fisher
Follow /20 May 2015 at 1:00pm / SQL Server

Adding new users & groups in windows

I do a lot of testing with security in SQL Server. And of course to do a thorough job of it I need not just SQL Server logins but Windows logins. And that means I need to be able to create and delete windows users and groups. I could do this with the...
99 0 /
Thomas LaRock
Follow /19 May 2015 at 5:54pm / SQL Server

SQL Server Backup Audit

I had a question come up last week from someone that wanted to know a few basic facts about their SQL Server backups for audit purposes. The facts they wanted were straightforward: Who took the backup? When was it taken? Where was it written? Simple questions...
117 0 /
Gethyn Ellis
Follow /19 May 2015 at 1:00pm / SQL Server

Getting Started with Microsoft Azure

By David Postlethwaite The URL for Microsoft Azure is http://azure.microsoft.com . Make sure you have an up to date browser because parts of this web site don’t work properly with Internet Explorer 8.The web site is full of articles, blogs and videos...
125 0 /