2011-09-12 (first published: 2011-09-02)
1,496 reads
Scripts
2011-09-09 (first published: 2007-11-19)
8,928 reads
Script a Database Role
Script one or all roles in a database. Includes users, obect permissions and column permissions.
2011-09-08 (first published: 2008-01-08)
5,262 reads
Generate Scripts to Compare Tables
Generate the scripts that will allow you to compare tables pass/fail.
2011-09-07 (first published: 2007-12-28)
12,549 reads
2011-09-05 (first published: 2007-01-25)
3,904 reads
2011-08-31 (first published: 2011-08-24)
2,504 reads
List all tables without LOB columns
Lists all the tables in a database that do not contain any LOB columns(text, ntext, image, varchar (max), nvarchar (max), varbinary (max) and xml).
Useful when rebuilding indexes online.
2011-08-30 (first published: 2011-08-25)
753 reads
2011-08-24 (first published: 2011-08-12)
1,157 reads
Consultando LDAP via SSMS
A query tem o objetivo de consultar o status do usuario AD via Management Studio.
2011-08-22
398 reads
Rastreando SysAdmin Habilitado
Script tem o objetivo de encontrar login com a role SysAdmin e informar seu status.
2011-08-22
215 reads
Blogs
Inspecting TSQL Abstract Syntax Trees
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
Becoming a creator, my website experience
By DataOnWheels
Over the past few months, I have debated starting a new blog to discuss...
T-SQL Tuesday #192 Invitation: SQL Server 2025 Excitement
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
Forums
Do You Really Need HA?
Comments posted to this topic are about the item Do You Really Need HA?
The New Database CheckDB
Comments posted to this topic are about the item The New Database CheckDB
MySQL’s BLACKHOLE Storage Engine: The Odd Feature I Wish SQL Server Shipped With
Comments posted to this topic are about the item MySQL’s BLACKHOLE Storage Engine: The...
Question of the Day
The New Database CheckDB
I run this code:
create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')
What is returned? See possible answers