SQL Server

SQL Server Community

SQL Server Blogs

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...
49 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...
60 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...
68 0 /
Mladen Prajdic
Follow /4 May 2015 at 2:00am / SQL Server

SSMS Tools Pack 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...
64 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...
95 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...
100 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...
107 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...
85 0 /
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...
100 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...
104 0 /
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...
122 0 /
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...
102 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...
97 0 /
Follow /29 Apr 2015 at 12:00pm / SQL Server

Better Together: Reduced Run Time and I/O

The run-time metric gets all the love, and for good reason.  It’s easily witnessed by end users and the one management cares about.  When DBAs have the task of cutting down the run time of a query, this typically starts in a non production environment...
92 0 /
Follow /29 Apr 2015 at 7:48am / SQL Server

BIG Data HACKATHON Copenhagen

The Microsoft Big Data Hackathon is your opportunity to hack for a good cause. Assemble a team, learn, share, and make new friends as you use big data technologies to solve real-world problems. Who Should Attend? This event is open to anyone interested...
116 0 /