SCRIPT: Find the row count of all tables and views
Today I’m sharing another script that I often find useful – Queries to find the count of rows from tables and...
2012-08-15
15,050 reads
Blog Posts
The Home Server is Back
After reading about the Amazon/Apple attack this morning, I grabbed a second cup of coffee and went in search of...
2012-08-15
711 reads
VM Guest Memory – Watch these numbers !
I have been using VMware vSphere client for a while now and the person who inspired me to use this...
2012-08-15
1,422 reads
Ctrl+R in SSMS 2012
After the successful installation of the SQL Server 2012, some shortcut keys can be possible to not work properly like...
2012-08-14
6,383 reads
Database and Disk Size - PowerShell Script
Every time we do a capacity analysis we need to analyse the database size (free and used) and the disk...
2012-08-14
6,041 reads
Database Certificates and the X.509 Standard
Hello Dear Reader, I came across an interesting discovery about a year ago and realized I’d never written about it. ...
2012-08-14
1,085 reads
Drive Size - PowerShell Script
The below script is used to find the disk size for a set of servers,
## Script to Find List of...
2012-08-14
2,005 reads
First Try at a Wooden Hand Plane
I’ve been reading about wooden hand planes lately (as opposed to hand planes made of metal that plane wood) and...
2012-08-14
888 reads
Fix: Crystal Reports Shows Red X Across Entire Page When Report Run Inside Visual Studio
I was googling (with Bing AND Google) like crazy for a solution to this, but didn't find one from any...
2012-08-14
2,029 reads
Modify Host File on Windows 7
Modifying the Windows host file can be a great way to ensure that you don’t accidentally modify production while doing...
2012-08-14
1,173 reads
Blogs
T-SQL Tuesday #198–Change Detection
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
Redgate and Rome
By Steve Jones
I’m at the UK Redgate office today, meeting with senior leaders in all areas...
Quick Tip: Check Most DTU Expensive Queries in Azure SQL Database
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding...
Forums
Creating a JSON Document IV
Comments posted to this topic are about the item Creating a JSON Document IV
Restoring Azure Key Vault Keys and Validating SQL Server TDE Recovery: Level 7 of the Stairway to TDE
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Restoring Azure Key Vault Keys...
Permissions Removal When Changing Object Schema
When the schema of an object is changed, SQL Server wipes out the previous...
Question of the Day
Creating a JSON Document IV
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers