Clean SQL Server Cache
I lives alone, usually, I clean my small apartment at every weekend, wipe the table/firniture with cloth, clean the capet...
2012-04-06
26,841 reads
Blog Posts
Designing Database Solutions for Microsoft SQL Server 2012 Beta exam (70-465 / 71-465) – My Thoughts
After sitting the Administering Microsoft SQL Server 2012 Databases Beta exam (71-462) on Monday, I was still a little disappointed...
2012-04-06
1,374 reads
Slacking Off: Planes, Trains, and Automobiles
It’s finally Friday. Grab a cup of coffee, a breakfast pastry of choice, and take a break with some non-SQL...
2012-04-06
813 reads
SQL Server - Index Fragmentation - Understanding Fragmentation
When I had a discussion with couple of my friends about index fragmentation, I realized that they have different understanding...
2012-04-06 (first published: 2012-04-05)
35,358 reads
SQL Server 2012: Installing on a Virtual Machine
Now that SQL Server 2012 RTM is out, I have an update to my blog post SQL Server 2012 (“Denali”): Installing...
2012-04-06
15,164 reads
Steady State vs Tempo
It’s helpful at work to understand things at work change from time to time and to consider the impact on you...
2012-04-06
1,003 reads
BACKUP LOG with TRUNCATE_ONLY is discontinued
As a follow up to an earlier posts - SQL Server - BACKUP LOG WITH NO_LOG
As of SQL Server 2008 , BACKUP...
2012-04-05
5,150 reads
Intel Sandy Bridge-EP Processor Recap
On March 6, 2012, Intel finally released the Xeon E5 processor family, (aka the Sandy Bridge-EP). Sandy Bridge is a...
2012-04-05
1,301 reads
More Fun with my NEST Thermostat
NEST has rolled out a nice software update for their NEST thermostat that gives you a 10 day history of...
2012-04-05
1,073 reads
Second TPC-E Benchmark Result Published For SQL Server 2012
NEC has submitted the second TPC-E OLTP benchmark result for SQL Server 2012, running on an Express5800/A1080a-E system, which is...
2012-04-05
1,664 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers