Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Columnstore Indexes: Finally Awesome in SQL 2016

Columnstore indexes are amazing for optimizing the performance of large rowcount queries that would otherwise look like a SCAN operation in an execution plan. Introduced in SQL Server 2012, they render the table read-only, however, and needed to be dropped (not even disabled) in order to insert/update/delete rows.

If you…

Read more

0 comments, 141 reads

Posted in SQL Tact on 21 April 2016

SSRS 2016 then SQL Jeopardy! tonight at BRSSUG!

See you tonight for our special SQL Jeopardy! competition where I will be your Trebek and three lucky user group participants will be our contestants!

Also a "special appearance" by our BRSSUG founder and Microsoft architect Patrick Leblanc, who will do a lightning round presentation on What's New in SSRS…

Read more

0 comments, 125 reads

Posted in SQL Tact on 13 April 2016

SQL Server PerfMon Counters Not Listed in dm_os_performance_counters

Had an issue with a new Azure VM install of SQL Server, but have had this issue in other, older places as well. SQL Server's performance counters in dm_os_performance_counters and/or perfmon have gone missing. How to get them back?

You might see a small subset of all performance counters here…

Read more

0 comments, 125 reads

Posted in SQL Tact on 5 April 2016

Azure ML and R at This Week's BRSSUG/BRPBIUG

This Wednesday night, not only are we going to be showcasing the technology of the internet with an online presenter from the other side of the world, but we're going to be seeing the first BRSSUG/BRPBIUG presentations on Azure Machine Learning and native R in SQL Server!

Really…

Read more

0 comments, 117 reads

Posted in SQL Tact on 7 March 2016

SQL Server Security Principals Lightning Round Presentation

Thanks for attending tonight's joint meeting of the Baton Rouge .NET/SQL/PowerBI User Groups, which was sponsored by Idera!

I presented a lightning round to the combined user groups on SQL Server Security Principals, which was a shortened version of a presentation I've given several times in the past. For this…

Read more

0 comments, 149 reads

Posted in SQL Tact on 10 February 2016

Easy Installing .NET 3.5 for SQL Admins

Rule "Microsoft .NET Framework 3.5 Service Pack 1 is required" failed.

This is a common problem and relatively easy fix for SQL admins installing a new SQL Server instance going back a few years, so it's about time to put all my notes about the solution into a single…

Read more

0 comments, 1,047 reads

Posted in SQL Tact on 21 January 2016

Announcing the Baton Rouge Power BI User Group

Baton Rouge is home to one of the inaugural Power BI User Groups, starting up soon! I'll be serving as its initial organizer, but I've already received a lot of feedback from the community and hope to form a new leadership team for the group soon.

Power BI is…

Read more

0 comments, 168 reads

Posted in SQL Tact on 5 November 2015

Congratulations New 2015-2016 BRSSUG Officers!

We elected new officers tonight for the Baton Rouge SQL Server User Group Official PASS Chapter, the second year in a row we've made an effort to do so.

We departed from a singleheaded user group mostly on the shoulders of a single volunteer. Prior to 2014, making things…

Read more

0 comments, 177 reads

Posted in SQL Tact on 14 October 2015

Presentation Downloads from SQL Saturday Columbus GA 2015

Thanks for joining us at SQL Saturday Columbus today on a gorgeous day to go inside and learn about SQL Server! And even bigger congrats to those of you who use Google maps and were still able to find the brand new event location at the Troy State University Riverfront…

Read more

0 comments, 229 reads

Posted in SQL Tact on 3 October 2015

Why I Don't Use the Architect Title

I get nervous when I see the title "architect" in IT job roles.

I've had this title before as an employer's standard, but lobbied against it. I instead prefer separating job titles from project roles.

Why?

"Architect" as an IT role descriptor carries an appropriate level of technical expertise and…

Read more

2 comments, 169 reads

Posted in SQL Tact on 28 September 2015

I Was Once a Very Crappy Carpenter + SQL Bolts to Buzzwords

Tonight I spoke to Dr. Alkadi's CMPS 411 class, which was hijacked by the Hammond .NET User Group onsite at Southeastern University! Thanks once again to Sparkhound who sponsored!

Here's the slide deck for my presentation, which combined two topics I wanted to talk about. The first, I Was Once…

Read more

0 comments, 252 reads

Posted in SQL Tact on 24 September 2015

Houston TechFest Presentation Downloads

Thanks for joining me at Houston TechFest 2015 at the NRG Center in Houston, TX! Big congrats to Michael and his crew of dedicated volunteers who once again put forward a first-rate free Saturday training event. I hope everyone enjoyed my presentations, our Sparkhound lunch session, our collar toss game…

Read more

0 comments, 218 reads

Posted in SQL Tact on 13 September 2015

SQL Saturday Baton Rouge 2015 Recap

SQL Saturday Baton Rouge 2015 was our 7th annual event, but we're still learning lessons. Here's my official Planning Committee Chair's recap of the event.


Here's one of the big new things we did this year:
  • We have a large, four-building facility for our event with multiple entry points. We…

Read more

0 comments, 300 reads

Posted in SQL Tact on 28 August 2015

Actual Emails: Allow NUNS to Lead You to Good Clustered Index Design

Wrote this email exchange with a colleague who wanted to confirm that the client-proposed design for a table was... less than optimal.


Subject: clustered index
From: A. Developer

Hey William,
I believe the client created this Clustered Index... <horrifying screenshot of a clustered index with many large nvarchar columns as…

Read more

0 comments, 232 reads

Posted in SQL Tact on 23 August 2015

Your Devs' Questions Answered With sys.dm_server_services

It starts with "I'm a developer...

"... with no RDP access, how can I tell if the SQL Server Agent service is running?"
"... and I don't think CDC is working. Is the SQL Agent on?"
"... how can I tell how long has the SQL Server been running? Did…

Read more

1 comments, 397 reads

Posted in SQL Tact on 20 August 2015

See you at SQL Saturday Baton Rouge 2015!

SQL Saturday is a global event to bring Information Technology speakers and professionals together for a community-driven, community-attended free day of technical training. The Baton Rouge SQL Saturday 2015 event is produced by the Baton Rouge User Groups, and will be our sixth annual event on campus at LSU. We…

Read more

0 comments, 279 reads

Posted in SQL Tact on 19 July 2015

SQL Server Permissions and Security Principals at Houston SQL Saturday 2015

Thanks to everyone who attended my presentation on SQL Server Permissions and Security Principals this morning at Houston SQL Saturday 2015!

What an awesome event! Please join me in sending a note of thanks and congratulations to Nancy Hidy-Wilson and the rest of the Houston Area SQL Saturday User Group

Read more

0 comments, 256 reads

Posted in SQL Tact on 13 June 2015

Error Upon First Processing Your SSAS Database With A Service Account

This blog post is to document the easy fix to a problem that has become a rite of passage for the good folks (including myself) on the data warehouse development team I've been working with recently.

Here's the error text you've probably received the first time you try to process…

Read more

0 comments, 476 reads

Posted in SQL Tact on 11 June 2015

Behavior of ORDER BY + UNION Can Be Confusing

This is an interesting example and it exposes a quirk with the concept of a UNION, which is, that the various subsets of a UNION cannot be guaranteed to be sorted by their subset character.

The difference is important to understand - it is the difference between a result set…

Read more

1 comments, 2,594 reads

Posted in SQL Tact on 8 June 2015

See You Next Weekend at SQL Saturday Houston!

Looking forward to speaking next weekend at SQL Saturday Houston 2015 on June 13!

If you haven't already registered for this great event, here's the link: https://www.sqlsaturday.com/408/registernow.aspx

This event will be held at San Jacinto College in Houston, and admittance to this event is free but there is a…

Read more

0 comments, 310 reads

Posted in SQL Tact on 5 June 2015

Older posts