SQL Server

SQL Server Community

SQL Server Blogs

Mike Walsh
Follow /22 Aug 2014 at 8:13pm / SQL Server

DBA Tunnel Vision

One of the things hammered into you in Firefighting training, Law Enforcement training, defensive gun use training and many other forms of training is “ Do not develop tunnel vision .” There is a reason they emphasize this concept so much...
14 0 /
Jason Strate
Follow /22 Aug 2014 at 5:00pm / SQL Server

Reblog: August 15 to August 21

Photo credit – Mike Lynch A good cure to a creepy doll is a good old post that is still useful. In this post, I’m going back over some of the posts that came out in this week in previous years. Having looked over these from time to time...
16 0 /
Pradeep Adiga
Follow /22 Aug 2014 at 2:35pm / SQL Server

How to extract the contents of .MSP files

I had encountered an issue while installing a SQL Server service pack. The resolution for it was to replace the existing SQL Server binaries from that of a Service Pack. To extract the contents of a Service Pack executable we need to just type “ServicePackExeName...
18 0 /
Tracy McKibben
Follow /22 Aug 2014 at 1:00pm / SQL Server

Friday Followup For August 22, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway. Posts That Were Popular This Week Cheating DBCC To Fix Index Corruption Don’t...
16 0 /
Ricardo Leka
Follow /21 Aug 2014 at 4:30pm / SQL Server

Snapshot

Esse script não tem nada de complexo, ele serve mais para ajudar a criar de uma forma dinâmica o SnapShot de uma base. Montei ele para funcionar da forma mais genérica possível, para bases com 1 arquivo até bases com 1000 arquivos. ele vai renomear...
33 0 /
Tracy McKibben
Follow /21 Aug 2014 at 1:00pm / SQL Server

Automated Source Control: A Librarian For Your Database Objects, Part 1

One of the biggest headaches in most development groups that do any sort of SQL Server work is that of source control.  There are some commercial products that attempt to solve this headache, and from what I understand, some of them do a pretty decent...
36 0 /
Dinesh Asanka
Follow /21 Aug 2014 at 4:10am / SQL Server

New Database Backup Options in SQL Server 2014

Short article on database backup options in SQL Server 2014. http://dbfriend.blogspot.com/feeds/posts/default?alt=rss
59 0 /
SQLDBAPros
Follow /20 Aug 2014 at 10:16pm / SQL Server

Solutions, Action, Results: Jenkon Dramatically Reduced Resolution Times

As a busy DBA, you are constantly pressed for time. You feel the pressure from your manager to work faster and more efficient—everyday. What would you think if we told you that you could reduce your resolution time by 70 percent? Sounds awesome...
48 0 /
Chris Yates
Follow /20 Aug 2014 at 3:00pm / SQL Server

ISPACs – Got To Love Em

Being a DBA and working with various teams, I have become accustomed to deploying SSIS packages. I’ll even go back further and, dare I say, DTS packages (I hope everyone did not just fall on the floor while reading that). Now-a-days this Database...
54 0 /
Derik Hammer
Follow /20 Aug 2014 at 2:00pm / SQL Server

Scripting Objects with PowerShell

The ability to script out the definitions of objects is valuable to any DBA. Most of us are intimately familiar with SQL Server Management Studio’s capabilities in this regard. Simply right-click on your object and navigate to the “Script...
59 0 /
Kenneth Fisher
Follow /20 Aug 2014 at 1:00pm / SQL Server

Two years!

Two years ago today I began my blog with a post about the DEFAULT keyword . I set out with the goal of building a blog I could be truly proud of in three years. One that was well liked and provided value to the community. Little did I imagine how much...
119 0 /
Pradeep Adiga
Follow /20 Aug 2014 at 12:35pm / SQL Server

Create and connect to a SQL Database on Windows Azure

Azure , is one of the fastest growing cloud platform by Microsoft. In this simple post, I will create and connect to a SQL Database on Microsoft Azure. To get started logon to the Microsoft Azure Management Portal  , navitage to SQL Database and click...
51 0 /
WaterOx
Follow /19 Aug 2014 at 3:00pm / SQL Server

Export a SSMS Query Result Set to CSV

Once you have a query that is returning the data you like in SSMS you have a few options to move the result set into a format that you can use in other tools. The simplest way is to select all results and then copy & paste them into whichever other...
49 0 /
Tom LaRock
Follow /19 Aug 2014 at 3:19am / SQL Server

HOW TO: Find Currently Running Long SQL Agent Jobs

A while ago I had posted a script to help find jobs that were currently running longer than expected. Since I’ve been sharing some scripts recently , I decided to verify that this script still works for finding long running jobs in SQL Agent for...
55 0 /
Chris Yates
Follow /18 Aug 2014 at 8:08pm / SQL Server

And Just Like That….Three Years

Time is a constant. Anything and everything requires time it seems, and with that said I received a reminder today that three years have passed since I first started this adventure called blogging. With this blog you will not find perfection, instead...
51 0 /