When It "Has" to Use SA...
As an infrastructure and security architect, I cringe any time any one mentions the following:
Domain AdminrootsaThose accounts can do anything...
2010-03-19
656 reads
Licensing SQL Server Reporting Services
I have my license here somewhere, officer.
Licensing models can sometimes make database modeling seem trivial. Per processor or per seat?...
2010-03-19
1,109 reads
SQL Log Shipping – by Abi Chapagai
SQL Server 2008 High Availability Solution: Log Shipping
In SQL Server, transaction log provides an ability to recover a database...
2010-03-19
1,726 reads
Being Involved in the Community
Regular readers know that I enjoy being involved in the SQL Server community. Over the last two and a half...
2010-03-19
346 reads
Tally Table CTE
Now that I have several posts on what you can do with a Tally table, I figured I'd share my...
2010-03-19
5,162 reads
Windows Themes (We need a PASS Theme!)
I imagine most of us change our wallpaper on the desktop from time to time. Frivolous but fun, a simple...
2010-03-19
872 reads
Losing Two Days
I’m off tomorrow to the UK for a week of work at the Red Gate offices, and then a couple...
2010-03-19
663 reads
Be Wary
We make mistakes when we publish things. It happens, and I am as guilty as some people of mistakenly putting...
2010-03-19
925 reads
Need to Persuade Your Manager or Co-Worker to Your Point of View?
At one time or another, each of us has been in a position where we need to persuade a manager,...
2010-03-18
570 reads
Want to Learn More About How to Master Microsoft Technologies?
If you want to learn more about how to master various Microsoft technologies, visit the website Born to Learn. This...
2010-03-18
1,440 reads
Blogs
Why AI isn’t paying off yet, and what to invest in first
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
Flyway Tips: Analytics Platforms (Snowflake and Databricks)
By Steve Jones
I’m really excited about some growth in Flyway support. I’ve been asking about this...
Paginated Reporting at Scale: Choosing the Right Microsoft Platform
By Rayis Imayev
"I've seen things you people wouldn't believe..."— Roy Batty, Nexus-6 Replicant, Blade Runner (1982)(2026-Nov-08) Yep,...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Table Partitioning in SQL Server: A Practical Guide to Managing Very Large Tables (VLDBs)
Comments posted to this topic are about the item Table Partitioning in SQL Server:...
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers