SQL Server

SQL Server Community

SQL Server Blogs

Dinesh Asanka
Follow /26 May 2015 at 3:31pm / SQL Server

Support for SQL Server 2005 Ends April 12, 2016

oduct expiration is a fact of life. And, no matter how much we love a product or no matter how long we cling to its familiar interface, we eventually have to give up on it. Such is the case with SQL Server 2005. SQL Server 2005 is the next in a running...
7 0 /
Kenneth Fisher
Follow /26 May 2015 at 1:00pm / SQL Server

Default database

What? The default database is one of the options when creating a login in SQL Server. This is the initial database that the login will connect to when logging in. Unless of course you specify a different database in your connection string. How? ...
21 0 /
Gethyn Ellis
Follow /26 May 2015 at 1:00pm / SQL Server

Microsoft Azure SQL Database – Dashboard

By David Postlethwaite Once you have created your database you can now start to manage and configure it. There are six menus for a SQL Azure Database: - Dashboard Monitor Scale Configure GEO-Replication Auditing and Security The Dashboard The Dashboard...
52 0 /
DBAFromTheCold
Follow /26 May 2015 at 12:54pm / SQL Server

SQL Server 2016 features I’m interested in

Microsoft announced this month what features/improvements will be in the next version of SQL Server, SQL Server 2016. You can download the datasheet they’ve posted from here . The features that have caught my attention are:- Enhancements to...
48 0 /
Mark Broadbent
Follow /26 May 2015 at 12:44pm / SQL Server

Want to choose your own agenda? From SQLSaturday to the PASS Summit!

OK so sadly Buck can’t be with us this year, but if he could, he would tell you to join our Programme Committee! This year, SQLSaturday Cambridge is pioneering the first ever Global Programme Committee for a SQLSaturday and we want you to be part...
51 0 /
Chris Webb
Follow /25 May 2015 at 5:35pm / SQL Server

Working With International Date And Number Formats In Power Query

One problem that can really drive you crazy when working with data from text files is the many different formats that dates and numbers can be stored in around the world. For example, take a look at the contents of a tab-delimited file shown in the following...
84 0 /
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
112 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...
104 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...
128 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...
99 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...
100 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 .
117 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...
120 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...
174 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...
124 0 /