Data Head
Well, it’s official. I am a Data Head. It doesn’t change too much my level of geekiness. But I may...
2011-09-27
781 reads
SQL University SSIS : Named Pipes -- Producer
Yesterday, I set up the premise for using named pipes in SSIS. Today we are going to get into the...
2011-09-27
713 reads
SQL Saturday in Iowa City This Weekend
In just a few short days, it will be time for SQL Saturday #98 in Iowa City. If you’ve got...
2011-09-27
718 reads
NOT IN or IN?
I have been having a hard time believing my eyes when I noticed that these queries give different results:
1. select...
2011-09-27
788 reads
KB2463332 failed to install
This morning I was working on getting all new inherited SQL Servers patched to current levels of service packs when...
2011-09-27
1,489 reads
workaround for orphaned users
The server principal is not able to access the database under the current security context, is the error message appears...
2011-09-27
407 reads
Missing indexes
One of the most common things I encounter when asked to help with performance problems, is wrong or inadequate indexing....
2011-09-27
1,435 reads
September 2011 SQL Server 2008 Instance Level Diagnostic Queries
Since it is late September, I thought it would be a good time to release an updated set of Diagnostic...
2011-09-27
1,251 reads
ALTER AUTHORIZATION sql to change owner of a database
ALTER AUTHORIZATION changes the ownership of entities . Server level entity ownership can be changed to server- level principals. Database level...
2011-09-27
101,594 reads
Paying for Free
It seems like there is a widespread malaise in the country these days. Everyone's clamoring to cut taxes -but no one wants to have their neighborhood school closed, or...
2011-09-26
13 reads
Blogs
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,...
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Alamat BCA KCP Mangunsarkoro Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Mangunsarkoro No.24, Pamoyanan, Kec. Cianjur, Kabupaten Cianjur, Jawa Barat 43211
Alamat BCA KCU CIANJUR Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. HOS Cokro Aminoto No.56-58, Muka, Kec. Cianjur, Kabupaten Cianjur, Jawa Barat 43215
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