Tags » Microsoft SQL Server

SQL Server Security Benchmarks

If you’re not familiar with the Center for Internet Security, here’s the organization’s mission statement:

The Mission of the Center for Internet Security is to enhance the security readiness and response of public private sector entities, with a commitment to excellence through collaboration.

265 more words
Syndicated

Update to "The clustered index columns are in all of the non clustered indexes."

I certainly hadn’t planned on creating a part two of this post but in the comments Jeremy Hughes pointed out that my understanding was if not incorrect, incomplete. 674 more words

Microsoft SQL Server

UNION vs UNION ALL

You might be wondering why I’m going into such a simple subject. Well the way I see it there are four options here.

  • You already know the difference, it seems really obvious and you are probably wondering why I’m mentioning it.
  • 359 more words
Microsoft SQL Server

October 13 Microsoft SQL Relay Reading.

Interesting talks at Microsoft SQL Relay Reading, the first SQL Relay event this year.

The Introduction to OLTP In memory from Amanda Ford and another lady from Microsoft covered some items I had not seen before: 289 more words

Microsoft SQL Server

SQL Server 2012 AlwaysOn

Starting Microsoft SQL Server 2012 version, the SQL Server clustering is called SQL Server 2012 AlwaysOn.

Recently, I have setup, configured, and installed SQL Server 2012 Clustering in VMware environment. 108 more words

Microsoft SQL Server

SGBD!

SGBD, é a sigla para Sistema de Gestão de Base de Dados! :)

ou

Em inglês: DBMS, Data… 245 more words
Base De Dados

Slides and Code for SSIG Talk

Thank you for those who made it out to the SQL Server Innovators Guild last night in Greenville, SC. I hope you enjoyed the talk and that it’ll create conversations about how we better secure the ETL pipeline. 50 more words

Syndicated