Speaking Twice on Oct 1, 2013
Carolina Technology Conference:
To start things off, I'll be speaking in the morning at the Carolina Technology Conference. I have a...
2013-09-30
2,815 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
Installing SQL Server 2008 on a machine with .NET Framework 4.0? Read this.
The SQL Server Premier Field Engineer blog has a post about an issue with installing SQL Server 2008 on a...
2013-09-23
2,070 reads
PASS BoD: I'm voting for Allen Kinsel
There are some very good names up for this year's PASS Board of Directors. However, I wanted to write a...
2013-09-23
2,385 reads
Don't Rush When It Comes to Privacy Data
The Dataloss list sent the following article through yesterday afternoon:
Obamacare Employee Accidentally Sends Out 2,400 Social Security Numbers
This is concerning,...
2013-09-17
2,227 reads
Why Government Required Backdoors Are a Bad Idea
I've heard the argument, "I've got nothing to hide. If it helps them catch the next guy, I'm all for...
2013-09-17 (first published: 2013-09-11)
3,985 reads
Good Advice on "Certification"
Buck Woody (blog | twitter) is often seen as one of the wise men of the SQL Server community and with...
2013-09-13 (first published: 2013-09-10)
2,642 reads
Database DoS Whitepaper from Securosis
Securosis has released a whitepaper on their research with regards to database denial-of-service attacks. This whitepaper is platform agnostic. It...
2013-09-11
2,040 reads
Sometimes I don't understand Microsoft's vulnerability classifications
Here's a great example:
MS13-079 - Vulnerability in Active Directory Could Allow Denial of Service (2853587)
Basically, this patches a vulnerability where an...
2013-09-10
1,883 reads
Good Intro Podcast on Hadoop
Have you heard about Hadoop but don't know much about it? What about "big data?" Would you like an intro...
2013-09-09 (first published: 2013-09-03)
2,111 reads
Is Microsoft's Certification Program Value Microsoft's Fault?
I'd be interested if anyone says, "No," to that question. Gail Shaw raised a few points in this post about...
2013-09-04
2,001 reads
Blogs
Using the Data API Builder–VS Live San Diego Resources
By Steve Jones
Thanks for attending my sessions. Resources below: Slides: Using Data API Builder GitHub repo: ...
Running a Local LLM On Your Laptop Resources
By Steve Jones
Thanks to everyone that attended my sessions at VS Live San Diego yesterday. It...
Differences Between xp_readerrolog and sp_readerrorlog: #SQLNewBlogger
By Steve Jones
I was creating a question on sp_readerrorlog and realized that this procedure is different...
Forums
Nomor Resmi Akun WhatsApp Bank BCA (0818751777)
WhatsApp resmi Halo BCA tersedia di nomor 0818751777. Layanan ini dapat digunakan untuk mendapatkan...
Layanan Halo BCA 24 Jam - Nomor Resmi 0818751777
Layanan Halo BCA dapat dihubungi melalui nomor resmi 0818751777. Layanan ini mencakup bantuan terkait...
Implementing Type 4 Slowly Changing Dimensions in SQL Server
Comments posted to this topic are about the item Implementing Type 4 Slowly Changing...
Question of the Day
The Disabled Index
I run this code on SQL Server 2022.
CREATE TABLE Drink
(
drinkid INT NOT NULL
CONSTRAINT DrinkPK PRIMARY KEY CLUSTERED,
drinkname VARCHAR(20),
rating NUMERIC(2, 1)
)
GO
INSERT INTO Drink
(
drinkid,
drinkname,
rating
)
VALUES
(1, 'Margarita', 4.5),
(2, 'Mojito', 4.3),
(3, 'Old Fashioned', 4.7),
(4, 'Martini', 4.4),
(5, 'Cosmopolitan', 4.2)
GO
ALTER INDEX drinkpk ON dbo.drink DISABLE
GO
SELECT * FROM dbo.Drink
GO
What is the result? See possible answers