SQL Server

SQL Server Community

SQL Server Blogs

Tracy McKibben
Follow /6 Mar 2015 at 1:00pm / SQL Server

Friday Followup For March 6, 2015

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 Do You Need...
19 0 /
Jen McCown
Follow /6 Mar 2015 at 12:57pm / SQL Server

Fun-fun-fun in the London sun (and Cardiff, and Exeter!)

We’re in London right now for SQLBits, which has been ABSOLUTELY LOVELY so far. If you’re anywhere near Cardiff, Wales on Monday 9th, or Exeter, England on Tuesday 10th, then you should hit the user group meeting, as we’ll be speaking...
13 0 /
Nakul Vachhrajani
Follow /6 Mar 2015 at 8:52am / SQL Server

Temporary Post Used For Theme Detection (b062971d-d8e6-4e08-a5b8-be3b14b42b3b – 3bfe001a-32de-4114-a6b4-4005b770f6d7)

This is a temporary post that was not deleted. Please delete this manually. (d3260a0c-5776-4d18-8f80-e83c9a3b0c7e – 3bfe001a-32de-4114-a6b4-4005b770f6d7) Filed under: #SQLServer
64 0 /
Colleen Morrow
Follow /5 Mar 2015 at 3:00pm / SQL Server

Exam Prep 70-463: SSIS Transactions and Checkpoints

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012.  So far, we’ve covered: Tables and Schemas in the data warehouse Dimensions and Slowly...
100 0 /
Chris Shaw
Follow /4 Mar 2015 at 3:31pm / SQL Server

Tip # 5 – SQL Server Maximum Memory (Tips for SQL Server Performance and Resiliency)

This article is part 5 in a series on the top 10 most common mistakes that I have seen impacting SQL Server Performance and Resiliency. This post is not all inclusive. Most common mistake #5: Not Setting a Maximum Memory Default configurations are...
109 0 /
Derik Hammer
Follow /4 Mar 2015 at 2:00pm / SQL Server

Running PowerShell in a SQL Agent Job

When creating a SQL Agent Job to execute a PowerShell script, you have to decide which way that you want the PowerShell to run. Depending upon which version of SQL Server that you are using and which job step type that you choose, you might be running...
91 0 /
Stuart Ainsworth
Follow /4 Mar 2015 at 2:00pm / SQL Server

(Personal) Kanban Myths: The Myth of The Process

Recently, my friend Joe Webb has posted some great resources on Personal Kanban on his Facebook timeline.  Joe’s an influential guy in the tech community (particularly the #SQLFamily ), so I’ve been excited about the flurry of emails and comments regarding...
102 0 /
Kenneth Fisher
Follow /4 Mar 2015 at 1:00pm / SQL Server

I want to blog but …

I don’t know how to get started. Pretty simple. There are a number of free blogging sites out there. Personally I use WordPress. All you need to do is go to http://www.wordpress.com and sign up for a free space. I have a blog but setting it...
98 0 /
Ed Elliott
Follow /3 Mar 2015 at 6:25pm / SQL Server

Unit Test Sql Server Code

In part 3 of this series of blogs on "getting more agile" I am going to look at unit testing and why we need to do it. My code is perfect, I need no stinking tests Ah you are like me, my code is perfect as well, good point. blog end. ...
117 0 /
Ricardo Leka
Follow /3 Mar 2015 at 6:15pm / SQL Server

Powershell, Excel e SQL uma combinação excelente

Uma coisa muito legal em automatizar tarefas é a dificuldade que temos em planejar o que vai ser executado, a forma que vai ser executado e manter da forma mais genérica possível para garantir que vai funcionar na maior parte dos ambientes sem precisar...
92 0 /
Richard Douglas
Follow /3 Mar 2015 at 3:12pm / SQL Server

50 Shades of Brown – The Series

That’s right I’m cashing in on the “50 Shades” franchise and twisting it to meet my own sordid needs to tell you about something that is critically important to every business. But why Shades of Brown if it is critical? Everybody knows that it’s red alerts...
158 0 /
sqlbischmidt
Follow /3 Mar 2015 at 1:16pm / SQL Server

SSIS: Password Policy Rules Not Met When Creating Catalog

Last week I was at a client site showing them how to set up the Integration Services Catalog. We were walking through the steps in how to create it and we input the password into the Create Catalog configuration screen. It was a strong password, that...
97 0 /
sqlkris
Follow /3 Mar 2015 at 1:00pm / SQL Server

Interview with Brad Botz on Business Analysts

I recently met Brad Botz in a professional Facebook group we both belong to and found we we have much in common.  I really like databases and development, and Brad likes to read user’s minds.  Well not really, but see Brad is a Business Analyst...
182 0 /
Chris Webb
Follow /3 Mar 2015 at 1:00pm / SQL Server

Submit Your Feedback On BI Features In SQL Server V.Next

Following on from last month’s post on ideas for new features in SSAS Multidimensional, if you are interested in telling Microsoft what features you think should be added to the on-prem SQL Server BI tools in the next version you can do so here: http...
89 0 /
WaterOx
Follow /2 Mar 2015 at 11:51pm / SQL Server

Why do We Have to Be at Risk? Enough is Enough!

When Do We Say Enough Is Enough? Recently Anthem Blue Cross Blue Shield announced that the ‘private’ information of up to 80 million customer was stolen. It wasn’t anything about medical history taken, just all their customer’s...
115 0 /