SELECT *
FROM Posts
WHERE Date_Posted = 'July 2018'

Jul
25
2018

Managing SQL Logins in different environments

Speaking of security, in SQL Server we have the possibility of authenticating in two different ways, one it is based on Windows Authentication and allow Windows users (from a local computer or Windows domain) to…

Continue Reading »

Jul
18
2018

SQL Server system databases 101

It was the other day during the networking time in my SQL User group meeting when someone told the story of the new DBA that was joking about running “DROP DATABASE [master]”…

Continue Reading »

Jul
10
2018

T-SQL Tuesday #104 – Finding tables and columns in SQL Server

 This post is part of the T-SQL Tuesday, which is a monthly blog party on the second Tuesday of each month. Everyone is welcome and have the chance to write about SQL Server. This month’s host is Bert…

Continue Reading »