Tag : #entrylevel - SentryOne Team Blog

Tag: #entrylevel

What Does HIPAA Mean for the DBA?

What Does HIPAA Mean for the DBA?

Get an overview of HIPAA regulations along with compliance tips and best practices from a healthcare legal specialist from the point of view of the DBA.

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.

January Webinars Focus on Azure and Containers

January Webinars Focus on Azure and Containers

Kevin Kline (@kekline) invites you to three webinars coming up in January: A two-part series on the Azure platform, with Gavin Payne; and a session from Paul Stanton on running SQL Server inside Docker containers.

#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 : 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.

#EntryLevel : Compression & Data Types

Melissa Connors (@MelikaNoKaOi) walks through the basics of when SQL Server data will benefit from compression and illustrates cases when it will not.

#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 : 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.