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.

Surprising but True: the Basics are Still Difficult

I always look forward to new research from Unisphere Research, a division of Information Today, Inc., publishers of this magazine and other great products for data professionals. The latest report which you should read is "SQL Server Transformation: Toward Agility & Resiliency 2017; PASS Database Management Survey." READ MORE… Originally Posted April 07, 2017

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.

SQL Server on Linux – It's No Joke

Many thought it was an early April Fool's Day prank, but it was no joke: On March 7, 2016, Microsoft announced the beta release of SQL Server on Linux with the intention of shipping a full release of the product by 2017. Oh, and SentryOne already supports SQL Server on Linux! READ MORE… Originally Posted

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