Fill Factor and wasted space: Quick Tip
This is a little excessive, but here's a quick script to show you your fill factors per table that are...
2013-11-21
913 reads
Blog Posts
JFK
“There is little value in ensuring the survival of our nation if our traditions do not survive with it. And...
2013-11-21
630 reads
Learn About PCI Today
I’ll be presenting PCI for the SQL DBA today at 1 pm EST for the PASS Security Virtual Chapter. Depending...
2013-11-21
626 reads
Notes from SQLSaturday in Oregon Nov 16, 2013
I wanted to take time to thank our sponsors, speakers and volunteers for making #sqlsat265 a big success. Over 400...
2013-11-21
570 reads
Powershell in a Month – Day 3 – Commands
This is part of my Powershell Challenge, to learn more about Powerhsell (PoSh) using the Learn Windows Powershell 3 in a Month...
2013-11-21
1,337 reads
What Happens In Vegas…
…stays in Vegas, except when it comes to chocolate. After walking more than 1500 miles over the past 9 months,...
2013-11-21
511 reads
A pattern to do beginning of period calculations.
Beginning of period calculations are common things. Rolling month reports, queries to pull everything from last month etc require beginning...
2013-11-20
770 reads
Automated Permissions Auditing With Powershell and T-SQL: Part 6
Everybody still with me? Have you tried the script from Part 5? Did you notice how SLOW the Active Directory...
2013-11-20
775 reads
Backups and Consistency
I wrote about transactional consistency recently. Why do we need this?
Imagine that I have an orders table and an ordersdetail...
2013-11-20
1,042 reads
Indexing Fundamentals
First, lets understand what the types of indexes are. If you take a reference book, you have the two types...
2013-11-20
1,684 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Running SQLCMD II
Comments posted to this topic are about the item Running SQLCMD II
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers