Are You Security Minded?
It's fun to just sit and talk with people, never know what you'll learn or be forced to rethink based...
2008-12-09
738 reads
DBAs Still in High Demand
With the world economy on the downside, there is at least one bright light, and that is DBAs are still...
2008-12-09
1,106 reads
Leaving Live
Last week Steve Ballmer had issued a challenge to MVPs to have them try Live Search instead of their regular...
2008-12-09
665 reads
Managing By The Numbers Part 2
Managing by the numbers often gets a bad name among employees because it can lead to a lot of gaming...
2008-12-08
661 reads
Trying to Figure Out if SQL Server 2008 Data Compression Will Benefit You?
SQL Server 2008 (Enterprise Edition) offers row and page compression, which can potentially offer a boost in disk I/O in...
2008-12-08
1,515 reads
A Custom Trace
I have to admit that when I had a performance problem with some code, I would often fire up Profiler...
2008-12-08
702 reads
Using Result Set as Variable in Stored Procedure
I’ve been asked several times lately from non-SQL developers that are sometimes required to do some quick SQL work how...
2008-12-08
3,431 reads
Tampa Code Camp Notes
I attended the Tampa Code Camp this past weekend. It was located at the Kforce Building in Tampa, a very...
2008-12-08
1,108 reads
Managing By The Numbers Part 1
I have a long held belief that if you really care about results, you have to measure them somehow. The...
2008-12-07
318 reads
Starting a Technical Blog (Link)
Brent Ozar had a nice post recently on starting a technical blog, well worth reading and a good addition to...
2008-12-07
281 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
Alamat BCA KCP Iskandar Muda Telp/Wa:0821-8200-233
Hub CS 08218200233 Jl. Sultan Iskandar Muda No.Kav. 80/1-2, RT.2/RW.3, Kby. Lama Utara, Kec....
BCA KCP Panglima Polim Raya Tlp:0821-8200-203
Telp/Wa 628218200203 Ruko Grand Panglima Polim, Jl. Panglima Polim No.16-17, RT.2/RW.1, Pulo, Kec. Kby....
Alamat BCA KCP Kota Kasablanka Tlp/Wa:0821-8200-174
Hub CS 08218200174 1st Floor – Unit B EightyEight@kasablanka, Jl. Raya Casablanca No.Kav. 88,...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers