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

Quickly Add Telnet

Have you found yourself on a server or workstation that doesn't have telnet, 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 'telnet' is not recognized as the name of a cmdlet, function,…

Read more

0 comments, 86 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, 174 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,018 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, 201 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,623 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, 147 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, 128 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, 104 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, 113 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, 133 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, 132 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, 146 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, 148 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, 219 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,464 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,764 reads

Posted in SQL Tact on 23 April 2014

South Alabama Day of .NET Presentations Downloads

I have been running into longtime SQL Saturday friend Ryan Duclos at SQL Saturday events in Baton Rouge and Pensacola since the beginning SQL Saturday days, so when he headed up a Day of .NET in Mobile, AL at the University of South Alabama, I was happy to join the…

Read more

0 comments, 206 reads

Posted in SQL Tact on 29 March 2014

South Alabama Day of .NET 2014

About 200 miles east of Baton Rouge there lies a beachside town called Mobile, AL that will settle down long enough from spring break to host the first South Alabama Day of .NET at the University of South Alabama. The wife and I are looking forward to presenting at the…

Read more

0 comments, 162 reads

Posted in SQL Tact on 27 March 2014

Data Architecture Virtual Group - Whiteboard Data Architecture Presentation

Thanks to all 130+ folks who joined, suffered my jokes and handwriting, and asked fantastic questions during my presentation to the SQL PASS Data Architecture Virtual Group meeting.

We covered three large project templates, including an end-to-end application and Data Warehouse, a SharePoint-list driven Data Warehouse, and an "Access Jailbreak"…

Read more

0 comments, 249 reads

Posted in SQL Tact on 27 February 2014

Acadiana SQL Server User Group - Introduction to SQL Server Security Principals and Permissions

Great crowd last night and a great job by organizers Glenda Gable and Jill Joubert for the very first meeting of the Acadiana SQL Server User Group! I'm looking forward to seeing another solid SQL Server networking community in place and growing, just an hour west of us in Baton…

Read more

0 comments, 192 reads

Posted in SQL Tact on 26 February 2014

Older posts