#SQLServer Weekly 20150907 – the Best New SQL Server Content of the Week

Welcome to #SQLServer Weekly!

image

Here is a roundup of SQL Server content from this past week ordered by their social sharing volume.  I manually gather the most shared SQL Server content in Twitter, Facebook, Google+ and LinkedIn.

“Now Hiring: Build Our SQL Server Triage Specialist Team (Remote Position) – Brent Ozar Unlimited®”
WHAT DOES A SQL SERVER TRIAGE SPECIALIST DO?

Publish date: 9/7/2015
Social sharing volume in the past week:
21 16 19 0

“Automating SQL Server Configuration with PowerShell and WMI”
I’ve been working recently with provisioning of Windows Server/SQL Server machines in AWS. I never imagined how hard it is to automate Windows and SQL Server configuration. After several days, I figured out how to do all that I needed, and since this was very stressful and painful, I’m here to share that knowledge 🙂

Publish date: 9/1/2015
Social sharing volume in the past week:
5 45 29 0

“SQL Server 2016 – TempDB”
With the release of SQL Server 2016 which is due out somewhere around March through May potentially 2016 (exact release dates still to be finalised) some changes have been made around the installation process. The SQL Server Installation Center is still the same with needing to navigate to the Installation tab before selecting “New SQL Server stand-alone installation or add features to an existing installation” to begin the installation process via the GUI.

Publish date: 8/31/2015
Social sharing volume in the past week:
2 2 13 2

“Microsoft’s SQL Server 2016 CTP 2.3 now available to download – Petri”
Microsoft has announced today that SQL Server 2016 CTP 2.3 (Community Technical Preview) is now available for download. While Microsoft does call this build a preview, they did say that they have already deployed the build into production in the SQL Azure database.

Publish date: 9/2/2015
Social sharing volume in the past week:
14 4 1 1

“Retrieving Table Metadata from SQL Server Catalog Views”
All database systems that I’ve worked with have some sort of system tables that provide information about the tables, columns, indexes, constraints, etc in a database. SQL Server is no exception; in fact there are different ways of querying its System Catalog. We’re going to look at one of these: Catalog Views, which can be queried easily.

Publish date: 9/1/2015
Social sharing volume in the past week:
1 7 3 1

“SQL Server Management Studio August 2015 Preview #SSMS”
Here is another installment of SQL Server Management Studio (SSMS) August preview, no need for any special introduction about SSMS tool as it provides/manages any sort of work for a SQL Server user not specific to Developers or DBAs.

Publish date: 9/4/2015
Social sharing volume in the past week:
3 1 6 0

“Reset table auto increment column in ms sql server – Sweksha”
If we want to reset the auto increment value of any table to any other value than default value, we need to use DBCC query.

Publish date: 9/3/2015
Social sharing volume in the past week:
1 7 0 2

“SQL Server 2016 Community Technology Preview 2.3”
Get your implementation knowledge ready (again) with this latest release of SQL Server 2016 CTP 2.3. If you haven’t attempted to see what’s new or what’s coming on with SQL Server 2016 (CTP) then this is the opportunity to know more about the product & technology!

Publish date: 9/3/2015
Social sharing volume in the past week:
3 1 6 0

“Introduction to Common Table Expression (a.k.a CTE) in Sql Server”
This is the first article in the series of articles on Common Table Expression in Sql Server. Below are the other articles in this series

Publish date: 9/4/2015
Social sharing volume in the past week:
1 5 1 1

“Data Paging by OFFSET…FECTCH and CTE – Sql Server”
When we have huge result set it doesn’t make sense to return the complete result set to the application and leave it to the datagrid, gridview or any other data control to handle the data paging. Because it wastes lot of network resources, puts pressure on the database server and the application server, so it makes page loading very slow. In such scenario it makes sense to return only the rows which needs to displayed on the current page, when user clicks next page/next result set then bring the next set of rows. In this way it reduces the unnecessary network traffic and load on the data base server, which in-turn helps in faster loading of the page.

Publish date: 9/4/2015
Social sharing volume in the past week:
1 3 1 2

“Multiple CTEs in a Single Query – Sql Server”
This is the third article in the series of articles on Common Table Expression in Sql Server.

Publish date: 9/4/2015
Social sharing volume in the past week:
1 4 1 1

“Recursive CTE – Sql Server”
This is the second article in the series of articles on Common Table Expression in Sql Server.

Publish date: 9/4/2015
Social sharing volume in the past week:
1 4 1 1

Leave a Reply