Role-playing Dimensions
Dimensions are often recycled for multiple purposes within the same database. For instance, a “Date” dimension can be used for...
2011-11-28
4,887 reads
Blog Posts
SQL Dirty Pages
Lazy writing , eager writing and checkpoint use asynchronous IO in writing pages to disk. The purpose of asynchronous IO is...
2011-11-28
12,269 reads
SQL Server A to Z – Waits
In the world of SQL Server, a process is either running, runnable, or waiting. A running process is, obviously, running;...
2011-11-28
901 reads
What Opportunity Are You Looking For?
http://www.flickr.com/photos/mencho-22/6218974134/
A lot has been happening this year. I decided to throw my hat in the ring at being a blogger...
2011-11-28
745 reads
And the winners of SafePeak’s SQL Server Performance Contest are...
SafePeak’s SQL Server Performance Contest – Winners
(In coordination with SQLAuthority.com) Back in September, 2011, SafePeak ran a new contest asking participants to share...
2011-11-27
1,854 reads
Installing SQL Server 2012 RC0 from an iPhone
Short version – Installed SQL Server 2012 RC0 onto a Server 2008 SP2 VM using an RDP connection from my iPhone...
2011-11-27
2,780 reads
MS Days 2011 in Albania, Tirana
I would like to write about the tech events in my country and our brother-neighbor Albania, that everyday we are...
2011-11-27
955 reads
Data Loading Performance Guide
Bulk loading with large amounts of data requires strategy. The Data Loading Performance Guide for SQL Server 2008 and SQL...
2011-11-26
3,634 reads
Hotfix for SQL Server 2008/2008 R2 Periodically Does Not Accept Connections Bug
Microsoft has released a hotfix for a very frustrating issue that plagued me for a couple of years at NewsGator. ...
2011-11-26
9,773 reads
Adelaide SQL Server User Group Slides and Scripts
You can find the slides and scripts from Monday’s Extended Events session for the Adelaide SQL Server User Group in the...
2011-11-25
527 reads
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
Bank CIMB Niaga Bandung - Asia Afrika (0813-7071-893)?
WhatsApp:08137071893 Wisma Cimb Niaga, Jl. Gatot Subroto No.2, Burangrang, Kec. Lengkong, Kota Bandung, Jawa...
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers