Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Fresh New Horror: PK on a Float Data Type

Here's a new thing to be scared about in the night, as if you weren't already terrified of floats after my previous two posts about the ills of the approximate-number data types.

Creating a primary key on a float data type can lead to what appear to be duplicate primary…

Read more

0 comments, 129 reads

Posted in SQL Tact on 11 May 2015

SSRS Utility Reports: Subscription Inventory, Failed Subscriptions

When delivering a SQL Server Reporting Services (SSRS) solution with lots of subscriptions, it's helpful to also include some utility reports about those subscriptions.

Here are a pair of queries you can use against the ReportServer database (in this case, SQL Server 2014) to generate some quick internal reports for…

Read more

0 comments, 177 reads

Posted in SQL Tact on 5 May 2015

Live Microsoft Event - Power BI Dashboard in a Day - Baton Rouge

Join BRSSUG Founder and Microsoft TSP Patrick Leblanc to learn how to use Microsoft’s self-service Business Intelligence platform, Power BI. In the first part of the session, the instructor will lead you through a Microsoft dataset and demo teaching you the basic elements of Power BI.

Each attendee should bring his…

Read more

0 comments, 150 reads

Posted in SQL Tact on 9 April 2015

Announcing: SQL Saturday Baton Rouge 2015

SQL Saturday Baton Rouge 2015 is coming up on August 2 at LSU, register today!

Email or instant message your friends, post it on your blog, tweet it on Twitter with hashtag #SQLSatBR - free training is coming soon for those interested in SQL Server, .NET development, SharePoint, Windows…

Read more

0 comments, 117 reads

Posted in SQL Tact on 22 March 2015

Quickly Add Telnet

Have you found yourself on a server or workstation that doesn't have telnet (typical in new builds and new Azure VM's from the gallery), and need it to test port connectivity? Did you receive this error when you tried to execute telnet in cmdshell or powershell?

telnet : The term…

Read more

0 comments, 202 reads

Posted in SQL Tact on 17 November 2014

Houston TechFest 2014: SQL Admin Best Practices with DMV's

Awesome crowd this morning for my SQL Admin Best Practices with DMV's presentation at Houston TechFest 2014, thanks very much for attending! There were some exceptionally useful questions raised today, great job to my audience.

Here is the .zip file as promised for my presentation slide deck and .sql…

Read more

0 comments, 229 reads

Posted in SQL Tact on 13 September 2014

Restoring Toggle Results Window as Ctrl+R in SSMS

Recent versions of SQL Server Management Studio have unmapped Control+R as the toggle for the Results window in a typical query window. Each time I work on a new SSMS environment or refresh my laptop, I find myself seeking out how to restore this setting.

Here's how, including a picture…

Read more

1 comments, 1,106 reads

Posted in SQL Tact on 3 September 2014

The Nine SQL Server Careers

Microsoft SQL Server is a mature and broad technology platform that supports a diverse set of careers - this blog post is an attempt to provide technical detail to my personal theory on careers in the Microsoft SQL Server world.

A mid-tier SQL Server professional who may carry the title…

Read more

2 comments, 590 reads

Posted in SQL Tact on 2 September 2014

Painful or Helpful? No SSMS Multiserver Results if One Instance Errors

I've been going back and forth with this question for a few days now.

If one instance in a multiserver query presents an error, no resultsets from any of the other instances are displayed, even if n "row(s) affected)" is displayed in the Messages tab.

This is particularly painful when querying dynamic management objects across server…

Read more

0 comments, 5,725 reads

Posted in SQL Tact on 26 August 2014

SQLSat Birmingham: SQL Server Admin Best Practices with DMVs

Thanks for attending my session today SQL Server Admin Best Practices with DMVs at 8AM!

Here's the link to a .zip file to download the slide deck and all sample files: http://1drv.ms/VH3mda

Read more

0 comments, 204 reads

Posted in SQL Tact on 21 August 2014

SQLSat Birmingham: SQL Server Permissions and Security Principals

Thanks for attending my session today, SQL Server Permissions and Security Principals at 9:15AM!

Here's the link to a .zip file to download the slide deck and all sample files: http://1drv.ms/VH3lpx

Read more

0 comments, 198 reads

Posted in SQL Tact on 21 August 2014

SQL Saturday Birmingham 2014

I'm looking forward to geauxing with a handful of Sparkhound colleagues and friends to speak at SQL Saturday Birmingham on August 23 at Samford University.

Fun trivia fact: This will be the first time I'll have spoken at a SQL Saturday east of Baton Roug

Read more

0 comments, 135 reads

Posted in SQL Tact on 19 August 2014

SQLSaturday Baton Rouge Business Intelligence and Recap - 2 of 2

(This is the second part of a two-part post on a SQLSaturday Baton Rouge 2014 recap.)

Out of a total of 614 attendees in house on August 2, 264 responded to our post-event cross-platform flurry of online survey invitations to surveymonkey. After reviewing this valuable feedback, it is definitely…

Read more

0 comments, 167 reads

Posted in SQL Tact on 10 August 2014

SQLSaturday Baton Rouge Business Intelligence and Recap - 1 of 2

(This is the first part of a two-part post on a SQLSaturday Baton Rouge 2014 recap.)

Been quiet on this blog the past few weeks as the crush of one of the world's largest SQLSaturday events arrives.

SQLSaturday #324 Baton Rouge this past Saturday was a big success for us…

Read more

0 comments, 201 reads

Posted in SQL Tact on 10 August 2014

SQL Saturday Baton Rouge 2014


Since I have been involved with and eventually head of the Baton Rouge SQL Saturday planning committee each year since 2009, my July's annually have been pretty hectic. Putting together orders for shirts and supplies, drinks, coordinating speaker communication, wrangling volunteers, working with sponsors, etc. But each year I am…

Read more

0 comments, 197 reads

Posted in SQL Tact on 10 July 2014

"What You Need To Know About Being a DBA and What You Need To Know That You Don’t Know Yet"

Last night was a big success for the first annual Baton Rouge User Groups Networking Night, an all-user-groups invited event that saw members of the Baton Rouge SQL Server, .NET, Java, IT Pro, SharePoint, Women in IT user groups, plus members of user groups in Hammond, Lafayette and New Orleans…

Read more

0 comments, 193 reads

Posted in SQL Tact on 10 July 2014

Baton Rouge SharePoint Saturday 2014: SQL Server Best Practices for SharePoint Databases

Thanks for joining us at the first annual Baton Rouge SharePoint Saturday!

Here is my presentation for the 1:15 presentation in Room 1, "SQL Server Best Practices for SharePoint Databases". Great discussion, great questions!

Click here to download the PowerPoint 2013 presentation.



Read more

0 comments, 205 reads

Posted in SQL Tact on 21 June 2014

Baton Rouge SharePoint Saturday

I'm thrilled to be joining many of my colleagues at Baton Rouge SharePoint Saturday this weekend at the Louisiana Technology Park. My friend and Sparkhound coworker Cody Gros, and the Baton Rouge SharePoint User Group, are bringing SharePoint Saturday to Baton Rouge for the first time.

SharePoint administrators,…

Read more

0 comments, 270 reads

Posted in SQL Tact on 16 June 2014

Using a Filtered Index to Enforce Filtered Uniqueness

One of the advantages and uses of Filtered Indexes (introduced with SQL Server 2008) is to provide filtered uniqueness. Obviously this has some implications, so please understand what you're trying to accomplish.

In the below example, we have a compound natural key of the two fields key1 and key2.…

Read more

3 comments, 1,575 reads

Posted in SQL Tact on 24 April 2014

Real heavyweights: Float vs Decimal, the Thrilla in Precision

This is a followup to a previous post where I likened SQL Server float datatype to Muhammad Ali. Specifically, I wanted to address the phrase "negligible data storage increase" to the test for different numeric data types.

In short, I will dismiss the notion that float provides a realistic advantage in…

Read more

1 comments, 1,902 reads

Posted in SQL Tact on 23 April 2014

Older posts