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...

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...

UNPIVOT a table using CROSS APPLY

I generally spend part of each day looking through http://www.stackoverflow.com, http://dba.stackexchange.com or http://www.sqlservercentral.com. I read through questions that have already...

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...

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...

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...

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...

Quick tip: Using sp_server_diagnostics

In SQL Server 2012 a new procedure sp_server_diagnostics returns a payload of information about server health and performance. The sproc...

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...

A Rickety Stairway to SQL Server Data Mining, Part 10.3: DMX Prediction Queries

by Steve Bolton
               In the last two installments of this series of amateur self-tutorials on SQL Server Data Mining (SSDM),...