SQL Server

SQL Server Community

SQL Server Blogs

Dinesh Asanka
Follow /5 May 2015 at 6:43am / SQL Server

SQL Server 2016 public preview coming this summer

Satya Nadella, CEO of Microsoft, announced SQL Server 2016 , an intelligent platform for a mobile first, cloud first world. The next major release of Microsoft’s flagship database and analytics platform provides breakthrough performance for mission critical...
42 0 /
Paul Turley
Follow /5 May 2015 at 2:40am / SQL Server

Microsoft DataZen Mobile Platform Available to SQL Server Enterprise Customers for Free

Last month Microsoft announced that they had acquired the DataZen mobile BI platform and were adding it to their enterprise BI product suite.  This is very exciting news that rounds out the Microsoft BI capabilities of their entire product portfolio...
97 0 /
James Serra
Follow /4 May 2015 at 8:13pm / SQL Server

TechEd is now Microsoft Ignite

In case you were wondering what happened to the TechEd conferences, Microsoft is now bringing together the best of previously individual events – the Management Summit, the Exchange, SharePoint, Lync, Project, and TechEd conferences – and then taking...
60 0 /
Jason Strate
Follow /4 May 2015 at 4:00pm / SQL Server

Monday Morning SQL Break – May 4, 2015

It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you don’t already, follow me on twitter ( @StrateSQL ). This is a good chance to catch up on data platform technology and career related information...
68 0 /
Kenneth Fisher
Follow /4 May 2015 at 1:00pm / SQL Server

Building a job to monitor other jobs

The other day Tom Roush ( b / t ) and Tim Radney ( b / t ) were having a discussion on twitter about using scheduled windows tasks to run SQL Processes. Now why would you ever want to do this? Well if you are running SQL Server Express then this may be...
75 0 /
Mladen Prajdic
Follow /4 May 2015 at 2:00am / SQL Server

SSMS Tools Pack 3.5.0.0 is out with a NEW feature, a few improved features and various bug fixes.

The new feature is called Global Replacement Texts . It gives you the ability to add custom replacement texts to your scripts in four different features. Licensing now gives you the ability to upgrade your existing license from the previous major version...
68 0 /
Dinesh Asanka
Follow /2 May 2015 at 7:46am / SQL Server

Which relational DBMS is best for your company?

There are lot of databases around you. What should I select from them. Lot of parameters you need to think. Database expert Craig S. Mullins examines the top relational database management system software to determine which best fits your organization...
99 0 /
Jen McCown
Follow /1 May 2015 at 1:08pm / SQL Server

Announcing Minion Enterprise: the new SQL Server Management Solution

A company with more than one SQL Server instance has no built-in way to gather and report on maintenance, backup, and configuration data across those instances. Even more, there is no good way to push standardized settings out to the enterprise. The database...
104 0 /
Dinesh Asanka
Follow /30 Apr 2015 at 1:56pm / SQL Server

Microsoft Introduces Azure SQL Data Warehouse

Microsoft today announced a new service in its Azure database lineup during its Build developer conference keynote today. The Azure SQL Data Warehouse, which will go into public preview in June, is meant to give businesses access to an elastic petabyte...
112 0 /
Chris Webb
Follow /30 Apr 2015 at 11:09am / SQL Server

Using Function.InvokeAfter() In Power Query

Last year I blogged about how to introduce a delay between web service requests in M code. Since then a new function has been added to Power Query which makes this a lot easier: Function.InvokeAfter(). This function doesn’t seem to be documented anywhere...
88 0 /
Richard_RP
Follow /30 Apr 2015 at 8:45am / SQL Server

Finding Locks on Tables

Recently I needed to find a stored procedure that was creating a lock on a table and updating the table regularly. So my starting point was the table name, but I needed to find where the commad was coming from that was locking the table, and what stored...
102 0 /
Thomas LaRock
Follow /29 Apr 2015 at 8:17pm / SQL Server

Troubleshooting Azure Connectivity: Ports and Endpoints

It was a simple enough question, or so I thought. One I felt should be either a simple “yes” or “no”. “Do we block remote desktop connections here?” Sure enough, I got back the quick and simple answer I expected, along with a question for myself. “Nope...
106 0 /
WaterOx
Follow /29 Apr 2015 at 3:30pm / SQL Server

They Can Do What? – SHUTDOWN

Reading Time: 1 minutes Many times the DBA is faced with the dilemma of granting excessive access to an application or user so it can ‘just work’. This can cause a lot of problems. There are commands that can be given from T-SQL that can...
124 0 /
sqlkris
Follow /29 Apr 2015 at 2:00pm / SQL Server

How to Write Queries – Write the Query – Step 3

This is the fourth of four articles in a series explaining the three simple steps I take to writing complex SQL statements.  The series starts with this introductory article . All the examples for this lesson are based on Microsoft SQL Server Management...
105 0 /
Kenneth Fisher
Follow /29 Apr 2015 at 1:00pm / SQL Server

Running Powershell scripts remotely.

I’ve only recently started to play with Powershell (PoSH) but even I’ve begun to discover what a huge number of tasks it can perform. Currently I’m working on a task to run SSIS packages remotely by using Invoke-Command to run DTEXEC...
100 0 /