SQL Server

SQL Server Community

SQL Server Blogs

Kevin Kline
Follow /29 Aug 2014 at 1:35pm / SQL Server

Four New Slide Decks for SQL Server and IT Pros from the DevLink 2014 Conference

I always enjoy presenting at the DevLink conference, presented each summer in middle Tennessee.  This year, I’m trying to be a better social media person and actually post my slides (in their most recent forms) on my SlideShare account for everyone...
156 0 /
sqlkris
Follow /29 Aug 2014 at 1:30pm / SQL Server

Get Ready to Learn SQL in an Interview with Dennis Still

I recently got to know Dennis through twitter and essentaiSQL.com.  If you’re non-technical, you’ll find this interview inspiring.  You too can learn SQL.  If you’re a techie or IT pro, Dennis provides great comments and insights on...
7 0 /
Tracy McKibben
Follow /29 Aug 2014 at 1:00pm / SQL Server

Friday Followup For August 29, 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 Don’t Get Slimed By Bad Parameter Sniffing...
6 0 /
Stuart Ainsworth
Follow /28 Aug 2014 at 10:55pm / SQL Server

What I Wished I’d Known Sooner As A DBA

Mike Walsh has put together an excellent topic for discussion , and I’ve read several responses to this; all of them are great, but most them are a little optimistic for my experiences.  I like to think that most of my friends and peers in the #sqlfamily...
24 0 /
DBAFromTheCold
Follow /28 Aug 2014 at 1:23pm / SQL Server

The Art of Performance Tuning

Performance tuning often gets called an art as people feel that a certain knack or innate talent comes into play. And whilst I don’t disagree that a certain level of knowledge is involved, I completely disagree that only certain people can performance...
54 0 /
Chris Yates
Follow /28 Aug 2014 at 1:04pm / SQL Server

What I Wish I Had Known Sooner…as a DBA

Yesterday I took a minute and to review some posts by some Data Professionals and in doing so I came across and article by Erin Stellato . She had been tagged by Mike Walsh  who posted an article regarding 4 Attitudes I Wish I Had Earlier as a DBA At...
44 0 /
Kendal Van Dyke
Follow /27 Aug 2014 at 7:13pm / SQL Server

Presenting At OPASS August 2014 Meeting On 8/28

Thursday night (8/28) I'll be presenting Inspector Insert And The Case Of The Mistaken IDENTITY for the Orlando SQL User Group (OPASS) . Identity values seem like a straightforward topic but as SQL Server has evolved different methods for working...
39 0 /
Mike Walsh
Follow /27 Aug 2014 at 4:16pm / SQL Server

4 Attitudes I Wish I Had Earlier as a DBA

Empathy – I sorely lacked that early in my career. I was chatting about this with Tom LaRock because I linked to his great post about empathy in a post about stuff I learned working in the ambulance a few posts back. I’ve actually had about...
51 0 /
Pradeep Adiga
Follow /27 Aug 2014 at 3:35pm / SQL Server

Export the Event Logs without opening MMC

I recently worked on a database corruption issue. In order to troubleshoot this I had to collect all the Event Logs from the server. But when I tried to open Event Viewer, MMC would fail with the following error. MMC could not create the snap-in. Name...
44 0 /
SQLDBAPros
Follow /27 Aug 2014 at 2:30pm / SQL Server

SQL Server “Wait Watchers”: Interpreting Data to Drop the Wait

Ever approached a SQL Server that has a performance problem and wondered where to start? Next time, try this… One of the most under-utilized performance troubleshooting methodologies in the SQL Server world is “waits and queues,”...
37 0 /
Kenneth Fisher
Follow /27 Aug 2014 at 1:00pm / SQL Server

Finding a job!

I’ve been told over the years that I’m pretty good at finding jobs. I mean in the last 25 years and 15 jobs or so (some contract positions) I’ve never been out of work for more than a month and a half at a time. I’ve always thought...
47 0 /
Derik Hammer
Follow /27 Aug 2014 at 1:00pm / SQL Server

Automate Service Account Password Changes with Powershell

I am a believer that regular rotation of passwords is an important security measure. I worked at an organization that, when they were small, would use the SQL Server database engine service account to run SQL Agent jobs and other processes. This account...
42 0 /
Tracy McKibben
Follow /27 Aug 2014 at 1:00pm / SQL Server

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

As I mentioned earlier , we use Perforce as our source control package, so all of the scripts presented here are written for Perforce.  I’ll try to clearly explain, in terms of source control, the functional parts of the script, so that you can...
39 0 /
Tom LaRock
Follow /26 Aug 2014 at 9:18pm / SQL Server

The Real SQL Server 2014 Power Feature (It May Not Be Hekaton)

Just a quick post today to tell you about a webinar I am doing on the 27th of August, 2014. The title is “The Real SQL Server 2014 Power Feature (It May Not Be Hekaton)”, and it is me talking about the new cardinality estimator (CE) in SQL...
71 0 /
David Dye
Follow /26 Aug 2014 at 2:12pm / SQL Server

SSIS Advanced Techniques Workshop

I recently completed a set of videos for SSWUG that covers some advanced techniques for SQL Server Integration Services. 1. SSIS – Creating dynamic packages 2. SSIS – Error handling and troubleshooting 3. SSIS – Deployment models 4...
42 0 /