Offset without OFFSET
A while ago Robert Cary posted an article on SQL Server Central entitled 2005 Paging – The Holy Grail which is,...
2012-04-26
2,034 reads
Blog Posts
See you at SQL Saturday 130 Jacksonville!
http://www.flickr.com/photos/rohicks/4788477593/
Hello Dear Reader, this Saturday April 28th is SQL Saturday 130 in Jacksonville FL! The good people from the Jacksonville...
2012-04-26
901 reads
SQL Server 2012 Diagnostic Information Queries (April 2012)
It is hard to believe, but SQL Server 2012 has been GA for nearly a month now. Because of this,...
2012-04-26
2,705 reads
SSWUG Expo..I'm up!
I am proud to say that one of the webcasts I taped last year for SSWUG is part of the...
2012-04-26
334 reads
The Mentoring Experiment – Cycle 2
It’s been a long time, almost a year since Andy Warren and I kicked off The Mentoring Experiment. We had...
2012-04-26
932 reads
UF Dissolves Computer Science Program, Increases Funding for “Future Jobs”
In a bold and decisive move earlier today, the University of Florida has decided to dissolve their computer science education...
2012-04-26 (first published: 2012-04-24)
3,817 reads
2012 (2011) Data Breach Report
I had a chance over the weekend to finish reading the Verizon 2012 Data Breach Investigations Report. It’s a compilation...
2012-04-25
1,110 reads
Creating a Symmetric Key in SQL Server
Symmetric keys in SQL Server are recommended for encrypting data in columns. They are a good balance of security and...
2012-04-25
12,531 reads
Enterprise Data Warehouse Architecture Options
Enterprise Data Warehouse Architecture Options
Of course, your architecture depends on your business requirements along with technical, historical, and political factors....
2012-04-25
4,281 reads
Setup database mirroring and log shipping together
SQL Server has multiple high availability solutions. Comparing with cluster, database mirroring and logshipping are easier to setup, and they...
2012-04-25 (first published: 2012-04-21)
12,423 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