MDX ClosingPeriod and PeriodsToDate
I’ve decided that the best way to spend a day of 104 degree weather is to sit inside and write...
2012-07-07
1,288 reads
This week’s links on monitoring SQL Server performance
From time to time, I will be posting links that I encountered during the week. This is also one way...
2012-07-06
839 reads
Find the size of Index in SQL Server
As we know, sp_spaceused gives the size of table and index but it gives the sum of size of all...
2012-07-06
7,505 reads
IOPS verses Throughput – Measuring Performance of Your Storage
Working on a recent consulting job, I was asked to explain the difference in throughput, which is, measured in MB/s...
2012-07-06
1,208 reads
The Standing Desk – In the Light
It’s been almost a month since I started the Standing Desk experiment. My first setup was down in the basement,...
2012-07-05
1,132 reads
Lost in Translation – Deprecated System Tables – sysconfigures
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-07-05
1,211 reads
Differences in the Null Bitmap between SQL 2005 and 2012
Hello Dear Reader, I’ve been working on a series for BIDN.com, the Business Intelligence Developers Network, on how to read...
2012-07-05
1,231 reads
SQL Server table partition switching
If you are using partitions in SQL Server, be aware that “partition switching” is a great feature to quickly truncate partitions...
2012-07-05
8,021 reads
Powershell Add-Member: IsLogBackupAllowed ?
In my previous post, I shared some of the issues I had when attempting to get Add-Member to work with...
2012-07-05
1,515 reads
SQL SERVER:How Can I Get Notification Alert When Fail Over Happened ?
It was long time I was searching for simple solution to get notification alert in my inbox when ever fail...
2012-07-16 (first published: 2012-07-05)
5,080 reads
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
What Did Healthy Look Like?
Comments posted to this topic are about the item What Did Healthy Look Like?
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers