Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Latest Blog Posts

New Pluralsight Course – LFCE: Advanced Linux Networking

My new course LFCE: Advanced Linux Networking in now available on Pluralsight here!

This course targets IT professionals that design and maintain RHEL based enterprises. It aligns with the Linux Foundation Certified System Administrator (LFCS) and Linux Foundation Certified Engineer (LFCE) and also Redhat’s RHCSA and RHCE Read more

0 comments, 84 reads

Posted in Anthony Nocentino's Blog on 16 August 2016

SQLPSX is Finally Getting Updated

The most current code is now on Github, with the Codeplex version being depreciated. You can read all about the planned updates from Mike Shepard.

The Future of SQLPSX
https://powershellstation.com/2016/07/13/the-future-of-sqlpsx/

SQLPSX Update
https://powershellstation.com/2016/07/31/sqlpsx-update/

Read more

0 comments, 154 reads

Posted in Everyday SQL on 16 August 2016

Script for creating test data for odds ratio

Make sure you have a working version of SQL Server 2016.

USE [master]
GO

/****** Object: Database [WorldHealth] ******/
CREATE DATABASE [WorldHealth]
CONTAINMENT = NONE
ON PRIMARY
( NAME = N’WorldHealth’, FILENAME = N’D:\Microsoft SQL Server\DATA\WorldHealth.mdf’ , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
LOG ON Read more

0 comments, 72 reads

Posted in Mala's Data Blog on 16 August 2016

Remember the Alamo (with a SQL Saturday nearby)

This past weekend was the first SQL Saturday in San Antonio, TX. I was lucky enough to get the chance to go, and I was happy to do so. I like to support new events in new cities, and hopefully I can help keep them going in the future.

I… Read more

2 comments, 176 reads

Posted in The Voice of the DBA on 15 August 2016

Query Store, Force Plan and Dropped Objects

I love the Query Store. Seriously. It’s a huge leap forward in the capabilities of Azure SQL Database and SQL Server in support of performance monitoring and query optimization. One of my favorite aspects of the Query Store is the ability to force plans. Frankly though, it’s also the scariest… Read more

5 comments, 865 reads

Posted in The Scary DBA on 15 August 2016

Temper, Temper

Possibly the single most influential event in my career happened over 25 years ago. I lost my temper at a client.

The client had requested a meeting. They had a new, complex, system they wanted implemented in the software we managed for them. The client was very very excited. I… Read more

7 comments, 585 reads

Posted in SQLStudies on 15 August 2016

What is Enterprise Architecture?

This is an interesting question. Lets look at couple of definitions starting with Wikipedia’s definition

“Enterprise architecture (EA) is "a well-defined practice for conducting enterprise analysis, design, planning, and implementation, using a holistic approach at all times, for the successful development and execution of strategy. Enterprise architecture applies architecture principles…

Read more

0 comments, 217 reads

Posted in The SQL DBA in the UK on 15 August 2016

Does sp_rename on a column preserve the ms_description?

Did some checking as couldn't find help in the MSDN documentation. My test on SQL 2016 shows that since the column_id isn't changing, the existing mapping of the description for the column is preserved.

I know it's probably pretty obvious, but I had someone ask me, so figured proving the… Read more

0 comments, 76 reads

Posted in SQL Barbarian on 15 August 2016

SQLSaturday Indianapolis Wrap-Up

This weekend, I attended SQLSaturday in Indianapolis for the first time. It’s one of the larger events in the Midwest and I’ve tried to schedule it for several years, but it’s always fallen on a weekend when I couldn’t attend. This year, the date finally worked out!

My presentation for… Read more

0 comments, 115 reads

Posted in The Data Files on 15 August 2016

Bigger Fact Table for Wide World Importers

Microsoft released a new sample database a couple of months back: Wide World Importers. It’s quite great: not every (unnecessary feature) is included but only features you’d actually use, lots of sample scripts are provided and – most importantly – you can generate data until the current date. One… Read more

0 comments, 1,035 reads

Posted in Koen Verbeeck on 12 August 2016

Are SQL Saturday’s Worth It?

This past weekend I was fortunate enough to be a part of Louisville’s (for those local the ‘ville) SQL Saturday event held at Indiana Wesleyan. Most of you who end up on this site are probably familiar with it, but for those that aren’t familiar with SQL Saturday events you… Read more

6 comments, 1,188 reads

Posted in The SQL Professor on 12 August 2016

CJIS and the Microsoft Cloud

Having a cloud you can trust is important. Microsoft takes security and compliance extremely seriously in both the commercial and government clouds. An August 2016 article on the Azure blog, Not All Clouds Are Created Equal, addressed this topic in detail discussing the impact of a CJIS compliant cloud… Read more

1 comments, 61 reads

Posted in Bradley Schacht on 12 August 2016

TGI SQL Friday – Weekly round up Friday 12 August 2016

This week has seen the launch of my new SQL Server newsletter in conjunction with Learning Tree. If you would like to sign up go to http://info.learningtree.com/sql-signup/and you’ll start receiving the regular newsletter, keeping you  up to date with the latest news and views in the world of…

Read more

0 comments, 106 reads

Posted in The SQL DBA in the UK on 12 August 2016

Using PowerShell to find Processor issues & more

One of the top three performance killers for SQL Server is lack of processing power. I’d say that it’s second only to storage latency and more of a concern than memory. Although with anything in SQL we can say it depends.

I’ve recently seen a lot of SQL Server instances… Read more

2 comments, 1,327 reads

Posted in Confessions of a Microsoft Addict on 11 August 2016

Tricky TSQL: NOT IN (NULL)

We’ve done this before, but we can go one better this time. Let’s take this step by step. NULL means “I don’t know”. It stand for an unknown value. Nothing can be equal to NULL. We simply can’t say that 1 = NULL, or ‘ABBA’ = NULL,  because we don’t…

Read more

1 comments, 580 reads

Posted in SQL Awesomesauce on 11 August 2016

Opening .SQL Files in SSMS 2016 by Default #SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

This is an easy one, but you’ll want to try this yourself.

As I’ve been trying to move off the various SSMS versions I have installed to… Read more

0 comments, 159 reads

Posted in The Voice of the DBA on 11 August 2016

Write-Only permissions

Yep, that’s right, you heard me. Write-Only not Read-Only. I was presenting SQL Server Security Basics at NTSSUG the other night and there was an interesting discussion on the idea of granting someone write permissions without corresponding read permissions.

So for example:

-- Setup code
CREATE LOGIN WriteOnlyUser WITH…

Read more

3 comments, 249 reads

Posted in SQLStudies on 11 August 2016

Regex With SQL Server - SQLSharp

In the context of my developer machine, I had log files I wanted to parse through. I setup a log library to output the results on a test server to a sql table instead of text files. However, this meant that my "log viewers" that handled regex parsing weren't in… Read more

0 comments, 1,580 reads

Posted in SQL Barbarian on 11 August 2016

Azure SQL Database vs SQL Data Warehouse

I am sometimes asked to compare Azure SQL Database (SQL DB) to Azure SQL Data Warehouse (SQL DW).  The most important thing to remember is SQL DB is for OLTP (i.e. applications with individual updates, inserts, and deletes) and SQL DW is not as it’s strictly for OLAP (i.e. data… Read more

1 comments, 1,145 reads

Posted in James Serra's Blog on 10 August 2016

What’s a Database Pipeline?

One of the things I ran into a few years ago was the idea of a software pipeline. A set journey across machines and stages that your software takes. In modern, DevOps style development shops, this usually means:

  • A development machine(s)
  • A Version Control System (VCS)
  • A CI/Build server/system
  • An…

Read more

2 comments, 1,424 reads

Posted in The Voice of the DBA on 10 August 2016

Newer posts

Older posts