How to Enable / Disable Xp_cmdShell in SQL SERVER? TIP #82
Friends,
Sometimes it might be possible that you have to run dos command from SQL SERVER. In such situation you have...
2015-02-05
26,429 reads
Blog Posts
Rochester PASS Chapter February Meeting - I'm Speaking!
On Thursday, February 26th at 6:00 PM EST I will be speaking at the Rochester PASS chapter meeting. The topic is “Easing Into PowerShell - What’s It All About?”.
You’ve been hearing a...
2015-02-05
4 reads
Excel BI Tip #18: Using CUBE Functions to Break Out of Pivot Tables
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2015-02-04 (first published: 2015-01-27)
7,932 reads
Some Thoughts About Microsoft’s Cloud Platform Roadmap
There have been a lot of changes in and around Microsoft in the past few months. Under the leadership of...
2015-02-04
444 reads
Some Thoughts About Microsoft’s Cloud Platform Roadmap
There have been a lot of changes in and around Microsoft in the past few months. Under the leadership of...
2015-02-04
181 reads
Clustered Columnstore Indexes – part 47 (“Practical Monitoring with Extended Events”)
Continuation from the previous 46 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
This post is a continuation from the the post 44, where I...
2015-02-03 (first published: 2015-01-26)
5,776 reads
Index Fragmentation in Azure SQL Database
Index Fragmentation in Azure SQL Database
FEBRUARY 4, 2015
Recently, I read the articles Stop Worrying About SQL Server Fragmentation and When Does Index Fragmentation Matter?, and that got me starting to...
2015-02-03
65 reads
POSTPONED to 02/11 - Speaking at the Omaha SQL Server User Group *Tomorrow* Night!
UPDATE - due to weather conditions today (snow this AM and sub-zero cold tonight) we are postponed to next Wednesday 02/11...
2015-02-03
917 reads
The most recent backup problem
When I first began this blog, back at the beginning of my DBA career, it was purely a place for...
2015-02-03
648 reads
TSQL Tuesday #63 – How do you manage security?
Come on down! You’re the next contestant on T-SQL Tuesday! I’m your host Kenneth Fisher and this month I’d thought...
2015-02-03
928 reads
Blogs
Flyway Tips: AI Helps with Commit Messages
By Steve Jones
At Redgate, we’re experimenting with how AI can help developers and DBAs become better...
Startup scripts in SQL Server containers
I was messing around performing investigative work on a pod running SQL Server 2025...
Using SQL Compare with Redgate Data Modeler
By Steve Jones
Redgate recently released SQL Compare v16, which included a new feature to work with...
Forums
What is Page Density
Comments posted to this topic are about the item What is Page Density
T-SQL in SQL Server 2025: Fuzzy String Search II
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Azure-SSIS, Self-Hosted Integration Runtime, & Data Gateway?
Looking to confirm my understanding of these three products and how they can be...
Question of the Day
What is Page Density
In SQL Server, there is a concept of page density. This is determined by how much data is stored on each page. What is a page density of 90%?
See possible answers