The Business of Publishing
Despite my casual approach to the editorials and my job, this is still
something of a business and Red Gate wants...
2007-07-10
631 reads
Blog Posts
CTEs and where have I been?
I haven't posted much lately, but it has been a busy few months with many family activities. At work, I...
2007-07-09
440 reads
DDL Triggers and CREATE_LOGIN/ALTER_LOGIN
I've been doing a lot with DDL triggers in the last week or so and pulling out the relevant information...
2007-07-09
1,148 reads
The Perils of NewID for Randomizing Results
NewID() is commonly used in the order by to return the result set in random fashion. No idea whether its...
2007-07-09
910 reads
Wiki For Books Online
Browsing MSDN this morning and saw the note that they now have Wiki support. If done well it could be...
2007-07-09
605 reads
Service Packs and Support
More coming next week in editorials and already a note on the site, but support for both SQL Server 2000...
2007-07-07
644 reads
Cursors to Increase Performance?
I recently had the chance to look over a friends shoulder at a query that needed some tuning work. In...
2007-07-06
717 reads
Latest Service Packs and Books Online
I was reading a new post at SQL Server Magazine titled The More Things Change(full version available to registered users...
2007-07-06
625 reads
Midlands PASS Chapter July Meeting with SQL Server MVP Wayne Snyder
SQL Server MVP Wayne Snyder Speaks on SQL Server Integration Services (SSIS)
Midlands PASS Chapter - July 12, 2007 Meeting
Sponsored by...
2007-07-06
783 reads
The Video World
I wonder what you think of this: video shorts. I've gottne the Lockergnome newsletters for years and they've proven interesting...
2007-07-06
608 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Pasar Kebayoran Lama,Telp/Wa 0821.3111.159
Jl. Raya Kby. Lama No.174, Cipulir, Kec. Kebayoran Lama, Kota Jakarta Selatan, Daerah Khusus...
BCA KCP Santa. Tlp;(+62) 85373737845
Jl. Wolter Monginsidi No.54, Petogogan, Kec. Kby. Baru, Kota Jakarta Selatan, Daerah Khusus Ibukota...
BCA KCP Radio Dalam,Telp/Wa 0821.3111.159
Jl. Radio Dalam Raya No.5 B-C, Gandaria Utara, Kec. Kby. Baru, Kota Jakarta Selatan,...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers