SQLStudies

DTS is dead, long live SSIS. Way back when SQL 2005 was announced then released DTS was pronounced DOA. SSIS...

2013-12-09 (first published: 2013-11-27)

3,184 reads

Finding the metadata for a query

by Kenneth Fisher

SQLStudies

You know I occasionally find it interesting how I learn new things. I was running through a practice test for...

2013-11-25

2,505 reads

A pattern to do beginning of period calculations.

by Kenneth Fisher

SQLStudies

Beginning of period calculations are common things. Rolling month reports, queries to pull everything from last month etc require beginning...

2013-11-20

773 reads

Connection options in SSMS

by Kenneth Fisher

SQLStudies

When connecting to a SQL Server instance in SSMS there are a fair number of options. Most DBAs I know...

2013-11-18

1,654 reads

Who’s on call

by Kenneth Fisher

SQLStudies

Every morning we have a daily meeting and my manager asks who’s on call. And every morning some form of...

2013-11-13

594 reads

A better way to find missing indexes

by Kenneth Fisher

SQLStudies

I recently attended SQL Saturday #255 and specifically the performance tuning pre-con put on by Grant Fritchey. It was a...

2013-11-11

975 reads

Physical Join Operators by Ami Levin

by Kenneth Fisher

SQLStudies

For those who don’t know the three physical join operators are Hash Match, Loop Join and Nested Loops. Understanding these...

2013-11-06

682 reads

sp_SrvPermissions & sp_DBPermissions V3.0

by Kenneth Fisher

SQLStudies

These are a couple of stored procedures I wrote to help me with security research. Each sp returns three data...

2013-11-11 (first published: 2013-11-04)

1,860 reads

Adding a column to a table with a default (NULL vs NOT NULL)

by Kenneth Fisher

SQLStudies

There are lots of ways to learn new things, or be reminded of old things. One of my favorites is...

2013-11-05 (first published: 2013-10-30)

5,176 reads

Change in SQL 2012 SSMS grid output behavior

by Kenneth Fisher

SQLStudies

It’s one of those things that always aggravated me but not really enough to complain about. When you run a...

2013-10-28

702 reads

SQLStudies

Finding active DTS packages

Finding the metadata for a query

A pattern to do beginning of period calculations.

Connection options in SSMS

Who’s on call

A better way to find missing indexes

Physical Join Operators by Ami Levin

sp_SrvPermissions & sp_DBPermissions V3.0

Adding a column to a table with a default (NULL vs NOT NULL)

Change in SQL 2012 SSMS grid output behavior

Blogs

Audit – Security Compliance Frameworks (Part 1)

Restore SQL Server Database to an OrbStack Container

Day of Data Baton Rouge Slides and Code

Forums

ALAMAT BCA KCU SUDIRMAN Telp 08218200174

ALAMAT BCA KCU KUNINGAN Telp 08218200174

ALAMAT BCA KCU PURI INDAH Telp 08218200174

Question of the Day

SQL Server Certificates