Skip to content
SQLDoubleG
Menu
  • Home
  • Articles
  • SQL-G Hacks
  • Language: English
    • English English
    • Español Español
Menu

Tag: SQL Server

T-SQL Tuesday #158, Implementing Worst Practices

Posted on Monday January 2nd, 2023

#tsql2sday is a monthly blog party on the second Tuesday of each month.  #tsql2sday is a monthly blog party on the second Tuesday of each month. Everyone is welcome to participate, so…

SQL Server system databases 101

Posted on Wednesday July 18th, 2018

In this post I want to give a basic explanation of what system databases are and things we can or cannot do with them It was the other day during the networking time…

T-SQL Tuesday #92, Lessons learned the hard way

Posted on Monday July 3rd, 2017

#tsql2sday is a monthly blog party on the second Tuesday of each month. Everyone is welcome to participate, so no matters you are an experienced blogger or you just want to start…

Successful Anti-Patterns, Using Deprecated Data types

Posted on Wednesday April 26th, 2017

From time to time it’s good to remind people about the complexity of a product such as SQL Server. The internals are so wide and complex that we easily get lost and…

T-SQL Tuesday #88 – The security audit WTF

Posted on Tuesday March 14th, 2017

In this post I want to share the stored procedure I wrote to audit the different logins and server permissions within an instance.    This post is part of the T-SQL Tuesday,…

Statistics and Data types, What can go wrong?

Posted on Thursday February 9th, 2017

One of the most interesting things in SQL Server are Statistics. Today I want to write about the creation and update. One of the most interesting things in SQL Server from my point…

Playing with Azure, Stretching Databases

Posted on Tuesday January 3rd, 2017

Whether we like it or not, the cloud is more and more present in our life as DBAs, so it is a good time to try understand some of the possibilities it…

Database Design Matters, Real World Scenario

Posted on Thursday November 3rd, 2016

Sooner or later the more you know how SQL Server works will help you come up with more and more ideas to solve your daily problems, let me show you what one…

Database Design Matters, choosing the Clustering Key

Posted on Wednesday September 21st, 2016

There has been a permanent debate about which is the right clustering key for our tables since the beginning of the time, this time I’ll get a bit deeper to show you…

Database design Matters, choosing the right data type

Posted on Tuesday September 6th, 2016

This is not the first time I write about best practices or how a good design can help even from a performance point of view, but today I’ll go to an earlier…

Posts navigation

1 2 3 Next
  • About this blog
  • Articles
  • Development
  • Free Training
  • Security
  • SQL Server 2016
  • SQL-G Hacks
  • T-SQL Tuesday

Latest Posts

  • T-SQL Tuesday #158, Implementing Worst Practices
  • T-SQL Tuesday #155 –The Dynamic Code Invitation
  • FillFactor, the Untold Story
  • How I Compared 1000’s of database’s schemas at once
  • How to Update SQL Server Stats The Right Way
©2023 SQLDoubleG | Design: Newspaperly WordPress Theme