SentryOne Team Blog (blogs.sentryone.com)

Tag : #IWantToShare

Announcing SQL Server 2017 Release Candidate

Microsoft announced the first release candidate (a.k.a. RC1) for SQL Server 2017 on Monday, July 17th. Release candidates are not a final and finished product, but they are feature complete. No new features are expected after Microsoft moves into the RC phase, only adding polish (for example, brushing up the documentation and UI) and performance […]

My First PowerShell : A Simple Story with Dramatic Flair

My First PowerShell : A Simple Story with Dramatic Flair

Melissa Connors (@MelikaNoKaOi) walks through and discusses lessons learned from her first PowerShell script, which restarts a range of remote computers.

#BackToBasics / T-SQL Tuesday : Are your backups worthless?

#BackToBasics / T-SQL Tuesday : Are your backups worthless?

For both T-SQL Tuesday and his #BackToBasics challenge, Aaron Bertrand (@AaronBertrand) provides some fundamental information about SQL Server backups, and why your restores can be just as important.

#BackToBasics : A Challenge for 2016

#BackToBasics : A Challenge for 2016

In every month of 2016, Aaron Bertrand (@AaronBertrand) will attempt to publish an introductory blog post about SQL Server.

#BackToBasics : CAST vs. CONVERT

#BackToBasics : CAST vs. CONVERT

Aaron Bertrand (@AaronBertrand) explains why he always opts for one of these options over the other, even in cases where it shouldn't matter.

#BackToBasics : Why I use lower case for data type names (now)

Aaron Bertrand (@AaronBertrand) explains why he codes defensively – matching the case of data type names, even in scenarios where it isn't strictly necessary.

#BackToBasics : Naming Stored Procedures

Naming conventions for stored procedures is the topic for Aaron Bertrand's 9th post for his #EntryLevel series.

#BackToBasics : Great Debates : Unicode

In his 8th #EntryLevel post, Aaron Bertrand (@AaronBertrand) takes a look at one of the classic debates in SQL Server : whether to support Unicode.

#BackToBasics : DATEFROMPARTS()

Aaron Bertrand (@AaronBertrand) continues his #EntryLevel challenge with July's entry, a treatment of DATEFROMPARTS() and similar functions introduced in SQL Server 2012.

#BackToBasics : An Updated

#BackToBasics : An Updated "Kitchen Sink" Example

Continuing the #EntryLevel challenge, Aaron Bertrand (@AaronBertrand) talks about optimizing the "kitchen sink" procedure using dynamic SQL and, optionally, OPTION (RECOMPILE).

#BackToBasics : Definitions of SQL Server release acronyms

Aaron Bertrand (@AaronBertrand) explains some of the more common acronyms you may see flung around in blog posts, Connect items, and Knowledge Base articles.

#BackToBasics : Dating Responsibly

As part of his #BackToBasics series, Aaron Bertrand (@AaronBertrand) gives four quick tips on using date and time values effectively in SQL Server.

#BackToBasics : The Beauty of the Synonym

Aaron Bertrand (@AaronBertrand) continues his "Back to Basics" series, this time discussing SQL Server's synonym and how it can be used.

#BackToBasics : The "Runaway" Query

Aaron Bertrand (@AaronBertrand) describes a few different causes for a symptom you might describe as a "runaway" query in SQL Server.

#BackToBasics : Common Table Expressions (CTEs)

Aaron Bertrand (@AaronBertrand) presents his first "BackToBasics" post of 2016, giving an introduction to common table expressions (CTEs).