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

DMV-6 : How well my store procedure doing ?……..sys.dm_exec_procedure_stats

sys.dm_exec_procedure_stats DMV (Dynamic Management View), described by BOL as follows : http://msdn.microsoft.com/en-us/library/cc280701.aspx
Returns aggregate performance statistics for cached stored procedures. The view...

Find SQL Server Installation – Date and Time – 2005 Onwards

SELECT create_date as ‘SQL Server Install Date’ FROM sys.server_principals WHERE name=’NT AUTHORITY\SYSTEM’

Las Vegas April 2013 UG Meeting

AlwaysOn – Finally, A usable ‘mirror’! In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are great, but the mirror/secondary database is not...

Las Vegas April 2013 UG Meeting

AlwaysOn – Finally, A usable ‘mirror’!
In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are...