SQL Saturday#197–Omaha Recap

This was the second SQL Saturday hosted in Omaha.  I loved to see how the event grew from the first...

DBA Question of The Day: What is SAVE TRANSACTION?

 Hello Dear Reader!  I was teaching a class in Chicago last week and I got a lot of really great...

SQL Server – Add Date/Time to output file of BCP / SQLCMD (2)

Last time I posted about How you can add date/time to output file name, in which I used xp_cmdshell to...

PASS Business Analytics Conference Live Blog

Apologies if you went to my site this morning to see my blog from the bloggers table at PASS Business Analytics...

PowerShell and SQL – Easy and Different Ways to Find Number of Rows of all Tables in a database

SQL Example:
DECLARE @TableRowsCount table

(

Tablename varchar(50),

cnt int)
insert into @TableRowsCount

EXEC sp_MSforeachtable @command1=” select ‘?’,count(*) from ?”
select * from @TableRowsCount
PowerShell Example:
Load SQL PowerShell by...

I See BI People

A tweet from Ted Krueger (Blog | @Onpnt) this morning…
I’m surrounded by BI people!!!!#passbac
— Ted Krueger (@onpnt) April 11, 2013

inspired a little creativity…

 
You...

Entertainment for the Traveling Consultant (UltraViolet Review)

Like many of us, I have a collection of favorite movies. These include Ghostbusters, Stripes, Serenity, and dozens more. I...

Discover, Diagnose, and Document ALL Your SQL Servers On Your Coffee Break

We all know that we should document our SQL Servers, right? RIGHT?
So let's say you had some time on...

SQL 2005 or above – Find Transaction Rate on a busy OLTP Database

Change Database name of a below mentioned query
DECLARE @cntr_value1 bigint

DECLARE @cntr_value2 bigint
SELECT ‘BEFORE’
SELECT @cntr_value1 = cntr_value

FROM sys.dm_os_performance_counters

WHERE counter_name = ‘transactions/sec’

AND object_name = ‘SQLServer:Databases’

AND...

PowerShell – CHECK, START and STOP SQL Services of a remote servers

Replace a valid server name in the following examples. Try to do a testing on your local machine and understand...