Skip to Content

greglow (314 Posts)

RSS

What’s in a name? How should SQL Server 2017 Graph Edge tables be named?

Posted July 09, 2017

By ,

In Uncategorized

Dennes Torres recently wrote a really excellent article introducing Graph Objects in SQL Server 2017. You’ll find it here:... more »
0

SQL Down Under Show 71–Joe Sack and Shreya Verma on Adaptive Query Plans and Graph API

Posted June 28, 2017

By ,

In Uncategorized

Hi Folks, I had the pleasure recently to record a podcast with an old friend Joe Sack who is working with Adaptive Query Plans in SQL Server 2017. Joining us... more »
0

More free SQL Server developer and DBA tools: May SDU Tools Release

Posted May 06, 2017

By ,

In Uncategorized

Hi Folks, We’ve just created the May 2017 update for SDU Tools. We’re pretty excited about what we’re delivering this month. The first part... more »
0

Avoiding invalid object name errors with temporary tables for BizTalk, Reporting Services and apps using SET FMTONLY

Posted April 10, 2017

By ,

In Uncategorized

When applications need to call stored procedures, they try to work out what the returned data will look like ie: which columns come back, what data types are... more »
0

Right-aligning numbers in T-SQL

Posted April 08, 2017

By ,

In Uncategorized

When you output a series of numbers in T-SQL, people often want to right-align the numbers. So instead of numbers that look like this: They want an output that... more »
0

PascalCase and camelCase strings in T-SQL

Posted April 07, 2017

By ,

In Uncategorized

Yesterday, I discussed changing the case of T-SQL strings to ProperCase, TitleCase, SnakeCase, and KebabCase. But there are other case options that can be... more »
0

Converting T-SQL strings to Proper Case, Camel Case, Snake Case, or Kebab Case

Posted April 06, 2017

By ,

In Uncategorized

Often when I’m moving data around (usually with SSIS but also with just T-SQL), I need to take text that is all capitalized or simply has messed-up... more »
0

March 2017 update for SDU Tools–More free tools for SQL Server developers and DBAs

Posted March 25, 2017

By ,

In Uncategorized

Hi Folks, As promised, tonight we’re releasing the monthly update to SDU Tools, our free toolset for SQL Server developers and DBAs. A download link will be... more »
0

Data Tales 12: The Case of the Code that Refused to Execute

Posted March 13, 2017

By ,

In Uncategorized

Hi folks, I’ve written another Data Tales article for SQL Server Magazine. This time, it’s SSIS (Integration Services) related.... more »
0

SSMS: Removing all tabs in your query window with spaces

Posted February 28, 2017

By ,

In Uncategorized

This is just a short post that I’ve been meaning to write for a while. I know that there is an eternal tabs vs spaces debate that goes on in development... more »
0