Maintaining Security and Performance using Stored Procedures Part I – Using EXECUTE AS
Anyone who knows me, or has worked with me, knows that I am a proponent of using stored procedures for...
2009-10-08
1,553 reads
A DBA’s Fantasy
I happened upon the screenshot below, showing a stress test in progress against a Windows machine with 64 quad-core CPUs...
2009-10-08
1,410 reads
Very Useful SQL Server 2008 High Availability White Paper On MSDN
Fellow MVP, Paul Randal from SQLSkills.com has published a 35 page white paper on MSDN called “High Availability with SQL...
2009-10-08
793 reads
BI Bootcamp with an Industry Expert
I’ve been a regular speaker at the DevTeach/SQLTeach events in Canada for the past several years. Jean-Rene Roy and his...
2009-10-08
449 reads
Oovoo
We've been doing video conference calls for work through LiveMeeting for a few months. After two years of audio only...
2009-10-08
619 reads
MSDE – Database Size Limit
Most of you are aware that the Microsoft SQL Server 2000 Desktop Engine (MSDE) limits database size to 2 gigabytes. ...
2009-10-08
9,658 reads
SQL Server MVP Deep Dives Early Access Edition Now Available
SQL Server MVP Deep Dives, a new book written by 53 SQL Server MVPs, is now available as an eBook,...
2009-10-08
569 reads
Newcastle Coders Group is Third Stop on Down Under Tour
I just made a whirlwind trip to Newcastle to speak at the Newcastle Coders Group, on “Getting the Most Out...
2009-10-08
403 reads
Sparse Columns – ConvertSVtoXML & XMLToResv
Not very often I run across something with zero matches in a search engine, but had it happen recently. I...
2009-10-07
362 reads
SQL Saturday #21 Orlando
It’s that time again! SQL Saturday has returned to Orlando with an all star group of speakers http://www.sqlsaturday.com/schedule.aspx. The event...
2009-10-07
749 reads
Blogs
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Forums
Communication, For Incidents and Life
Comments posted to this topic are about the item Communication, For Incidents and Life
PostgreSQL psql Meta Commands: Tables
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Tables
Building a Support Ticket Triage Report with IIF() and CHOOSE() in SQL Server
Comments posted to this topic are about the item Building a Support Ticket Triage...
Question of the Day
PostgreSQL psql Meta Commands: Tables
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers