Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Latest Blog Posts

Overview of Azure Data Services

The number of Microsoft’s cloud services is growing by month, if not week, so that it’s hard to keep them all in mind and understand what exactly is each one for and when to use waht. This article is a summary of the Data Service as of April 2015. I’ll… Read more

0 comments, 27 reads

Posted in Gorandalf's SQL Blog on 3 May 2015

Using SQL Code Guard TFS Checkin Policy with VS2013

To use TFS Checking policy the first thing that you must do - is to add policy to your TFS source control
The process itself is pretty simple

  1. Install SQL Code Guard at target computer. Please remember that you will need to have SCG installed on each computer on which…

Read more

0 comments, 40 reads

Posted in SQL Code Guard on 2 May 2015

Thanks for the Help with Deadlocks

It's time to start blogging again. And for my first post in a very long time, I mainly want to thank the SQL Server community for putting so much valuable information out there. Recently we had a rare deadlock appear, and it reminded me of a previous encounter I had… Read more

0 comments, 55 reads

Posted in Stephen Tirone - Adventures with Data on 2 May 2015

May 13th – Standardized SQL Installations – Script Review & Demo

This session is mostly demo-focused. I will cover prerequisites for scripts and show how to do multiple SQL Server installations using scripts and demonstrate how to Streamline SQL Server implementations.

Read more

0 comments, 79 reads

Posted in SQLFeatures on 2 May 2015

Building Your Data Team’s Make Up and Culture

Join Adam Jorgensen and Pragmatic works to learn about Building Your Data Team’s Make Up and Culture on Tuesday, May 5.


Read more

0 comments, 95 reads

Posted in DataOnWheels on 1 May 2015

Speaker of the Month: May 2015

I finally got out to some community events last month and got to see a bunch of great speakers. Not that you don’t see great speakers at paid events, you do. It’s just that they’re usually professional speakers and I want to encourage others when I can.

The Speaker of… Read more

4 comments, 79 reads

Posted in The Scary DBA on 1 May 2015

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 administrator must spend a large amount of…

Read more

3 comments, 288 reads

Posted in SQL Awesomesauce on 1 May 2015

Utilizing the power of table parameters to reduce IO, improve performance, decrease pollution, and achieve world peace...

I was dealing with a challenging dynamic sql procedure that allowed a .NET app to pass in a list of columns and a view name, and it would generate a select statement from this view. Due to requirements at the time, I needed the flexibility of the "MAIN" proc which… Read more

0 comments, 179 reads

Posted in BIT Barbarian on 30 April 2015

Excel BI Tip #26: Using a Data Spreadsheet or Tab

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly about using Excel 2013 and later.  Much of the content will be a result of my daily interactions with business users and other BI devs.  In order to not… Read more

0 comments, 101 reads

Posted in DataOnWheels on 30 April 2015

Elite VMware SQL Server Workshop Wrapup

This past week I had the pleasure of being part of the second SQL Server virtualization workshop held by VMware. The first workshop, held last year, was a tremendous success and we all wanted to keep the momentum going with more SQL Server gurus. Over the last few months,… Read more

0 comments, 70 reads

Posted in Technobabble by Klee from @kleegeek on 30 April 2015

Spinach and Database Development- SQLSatExeter Keynote

Last weekend, we held our SQL Saturday event in Exeter. It was a brilliant event for many reasons but we were delighted to have a world exclusive keynote video by Phil Factor about Spinach and Database Development. With many thanks to those that made it possible and particularly to Phil… Read more

1 comments, 100 reads

Posted in SQL DBA With A Beard on 30 April 2015

Azure SQL Database Elastic Scale Part 2 - The Shard Map Manager Database

Azure SQL Database Elastic Scale Part 2 - The Shard Map Manager Database
MAY 1, 2015

In my last post, I discussed some of the concepts around Sharding and how we could use Sharding and Azure Database Elastic Scale in a real world application to implement Horizontal Scaling. In…

Read more

0 comments, 145 reads

Posted in Pie in the Sky on 30 April 2015

Know About .MDF and .NDF In SQL Server

In SQL Server Records (Data) and log information is not stored in one file. There are three types of individual files used by SQL server to store its information. These files are Primary data file and secondary data file. These two individual files are used by one SQL server. These… Read more

0 comments, 89 reads

Posted in Zora's SQL Tips on 30 April 2015

Altering a column to add NOT NULL

I had to do this recently and needed to look up the syntax as I couldn’t remember it. I don’t do this often, but I was working on a particular item and wanted to test this.

I had a table, something like this:

CREATE TABLE SimpleTable ( MyID INT NOT

Read more

0 comments, 218 reads

Posted in The Voice of the DBA on 29 April 2015

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 do a lot of damage… Read more

3 comments, 107 reads

Posted in WaterOx SQL on 29 April 2015

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 on a remote machine. I’ll be posting the final… Read more

2 comments, 178 reads

Posted in SQLStudies on 29 April 2015

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, consisting of different server architecture… Read more

0 comments, 100 reads

Posted in Adam Kreul | Blog on 29 April 2015

DataZen Dashboards Update

I’ve spend a good three days on and off working with the new “Microsoft” DataZen dashboard tool and I think this is going to be significant addition to the enterprise BI offering.  It’s not quick and easy to setup the server, configure data sources, data view queries and design dashboards…

Read more

1 comments, 120 reads

Posted in SQL Server BI Blog on 29 April 2015

Outlier Detection with SQL Server, part 6.2: Finding Outliers Visually with Reporting Services Box Plots

 By Steve Bolton

…………Throughout this series of amateur mistutorials in using SQL Server to identify outliers, we have repeatedly seen that the existing tried-and-true methods of detection long used for such purposes as hypothesis testing are actually poorly suited for finding aberrant values in large databases. The same problem… Read more

0 comments, 92 reads

Posted in Multidimensional Mayhem on 29 April 2015

Older posts