SQL Server

SQL Server Community

SQL Server Blogs

Dinesh Asanka
Follow /25 May 2015 at 6:06am / SQL Server

Important Soft Skills for the Entry-Level Data Professional

Nice article about soft skills. Read more at http://sqlmag.com/database-administration/important-soft-skills-entry-level-data-professional http://dbfriend.blogspot.com/feeds/posts/default?alt=rss
61 0 /
Rohit Garg
Follow /25 May 2015 at 3:56am / SQL Server

Last Cumulative Update – 16 for SQL Server 2012 Service Pack 1 Is Now Available !

The 16th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft Support site. Cumulative Update 16 contains all the hotfixes released since the initial release of SQL Server 2012 SP1. Those who are...
69 0 /
Rohit Garg
Follow /25 May 2015 at 3:56am / SQL Server

Cumulative Update – 6 for SQL Server 2012 Service Pack 2 Is Now Available !

The 6th cumulative update release for SQL Server 2012 Service Pack 2 is now available for download at the Microsoft Support site. Cumulative Update 6 contains all the hotfixes released since the initial release of SQL Server 2012 SP2. Those who are...
92 0 /
Rohit Garg
Follow /25 May 2015 at 3:56am / SQL Server

SQL Server 2014 Service Pack 1 (SP1) Is Now Available !

Finally after a long waiting period, Microsoft release SQL Server 2014 Service Pack 1 (SP1), Same is now available for download at the Microsoft Support site. SQL Server 2014 Service Pack 1 (SP1) contains all the hotfixes released since the initial release...
71 0 /
derekewilson
Follow /24 May 2015 at 11:43pm / SQL Server

CDO Summit Toronto June 4th

I am presenting the lunch keynote at the Toronto Chief Data Officer Summit on June 4th.  My session is on how to leverage predictive analytics to reduce customer churn.  I will be going over how I leveraged a decision tree model to create a customer risk...
74 0 /
WaterOx
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 .
105 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...
108 0 /
sqlkris
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...
165 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...
116 0 /
MattSQL
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...
120 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...
127 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...
125 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...
136 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...
137 0 /
WaterOx
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 .
121 0 /