SQL Server

SQL Server Community

SQL Server Blogs

Ryan Adams
Follow /15 Apr 2014 at 9:30pm / SQL Server

Central Management Server White Paper

Below is a link to a white paper I wrote on Central Management Server.  This white paper is an excellent guide for those who have never used it before.  It walks you through how to use CMS from beginning to end.  Here is what you can expect to learn:...
23 0 /
WaterOx
Follow /15 Apr 2014 at 6:20pm / SQL Server

Why a Boot Camp?

As a some of you may already know, I am now offering SQL Server boot camps with the first one being this July in Washington DC. Over the last couple of weeks since I announced this I’ve had a few questions as to why I am offering a boot camp and more...
28 0 /
James Serra
Follow /15 Apr 2014 at 4:00pm / SQL Server

Parallel Data Warehouse (PDW) AU1 released

Microsoft’s PDW has seen a big boost in visibility and sales over the past year, and part of the reason is due to frequent upgrades to the hardware and software.  About every six months there is an appliance update, which is sort of like a service...
36 0 /
Ayman El-Ghazali
Follow /15 Apr 2014 at 1:55pm / SQL Server

[SQL Snacks Video] SQL Server Table Partitioning 102

Welcome back for part 2 of my SQL Snack Pack on Table Partitioning! If you have not watched the first video, I would highly encourage you to do so. In this second video I will discuss the following: Creating a new Range in our Partition for new data ...
39 0 /
sqlbischmidt
Follow /15 Apr 2014 at 12:31pm / SQL Server

Save an Excel table as a SharePoint List

Quick post today, but really handy. I recently had a list of values that I needed to save as a list on a SharePoint BI site. The good news is that this is much easier than I originally thought to accomplish. To demonstrate, I’ll start by opening up...
32 0 /
Rohit Garg
Follow /15 Apr 2014 at 10:33am / SQL Server

SQL Server 2000 || Disable sa login

Question : How to disable sa user in SQL Server 2000? Reason : Due to Security requirement of audit, We have to disable sa user for all SQL instances in environment having SQL 2000 \2005\2008 & 2008 R2. Answer : We can disable sa user from SQL...
28 0 /
SteveHood79
Follow /15 Apr 2014 at 9:00am / SQL Server

Optional Parameters Causing Index Scans

Optional parameters in a stored procedure often lead to scans in the execution plan, reading through the entire table, even if it’s obvious that the right index is in place. This is extremely common in procs that are used behind search screens where...
32 0 /
Chris Yates
Follow /14 Apr 2014 at 10:00pm / SQL Server

Windows Functions; Who Knew?

SQL windows functions, it would seem, get lost in the shuffle most of the time when dealing with SQL. Why do you think that is? I honestly think that it is more or less developers, DBA’s, and data professionals are oblivious to some of the cool...
45 0 /
Chris Shaw
Follow /14 Apr 2014 at 8:51pm / SQL Server

What a Great Weekend

SQL Saturday #297   On April 12 th we had the 3 rd SQL Saturday hosted in Colorado Springs, Co. The event meet and exceeded all of our goals, our goals may not line up with some of the other SQL Server Saturday traditional goals you may have heard...
41 0 /
prashanthjayaram
Follow /14 Apr 2014 at 7:32pm / SQL Server

SQL – Find encrypted objects using sql_modules or Powershell

The objects of type P, RF, V, TR, FN, IF, TF, and R have an associated SQL module SELECT sm.object_id, OBJECT_NAME(sm.object_id) AS object_name, o.type, o.type_desc, sm.definition, CAST(CASE WHEN sm.definition IS NULL THEN 1 ELSE 0 END AS bit)...
37 0 /
VSRaavi
Follow /14 Apr 2014 at 5:19pm / SQL Server

SQL Server – How To Find SQL Virtual Name From Host Name in SQL Failover Clustering Using PowerShell

Often times it is required to find out the SQL name from the host names in a clustered environment so you can use it to connect through SSMS. There are many ways you can achieve this, however I am showing 2 methods here. Method 1 is the most common way...
43 0 /
Jason Strate
Follow /14 Apr 2014 at 4:00pm / SQL Server

Last Weeks Top “Reading” Links #79

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” ( so exciting ), follow me on  twitter  ( @StrateSQL ).  And see these throughout the day as I tweet out links of things I find interesting...
45 0 /
Vinoth Nm
Follow /14 Apr 2014 at 3:54pm / SQL Server

Monitor and Alert SQL Stack dumps

As many of know not all stack dumps raise an error in SQL Server and may go unnoticed for days, SQL stack dumps can sometimes cause database corruption and its always better to analyse the server immediately after a stack dump. Since there are no errors...
44 0 /
Jen McCown
Follow /14 Apr 2014 at 2:05pm / SQL Server

MidnightDBA at SQL Saturday Houston – May 10

Sean and I will be speaking at SQL Saturday Houston on May 10, at San Jacinto College – South Campus 13735 Beamer Rd. Building 12 Houston, TX 77089 We have three sessions between the two of us: T-SQL Code Sins, Jen DBA Career Roadmap, Sean and Jen...
48 0 /
Kenneth Fisher
Follow /14 Apr 2014 at 1:00pm / SQL Server

Collation: Correction -> Instance

I had a recent run in with collation problems and it got me started reading about them. As I read I started to realize that for a seemingly simple subject there was a lot to it. So I thought I would go over some of what I found out. You’ve installed...
43 0 /