Planning Your 2010 Professional Development
Virtually all successful DBAs I know put a lot of focus on education, and the best way to make it...
2009-11-24
541 reads
The most optimal join type
What’s the best join type for a query? Should we aspire to seeing nested loop joins in all our queries?...
2009-11-24
986 reads
Planning Out a Holiday Weekend
I've got a four day weekend thanks to the Thanksgiving holiday here in the United States. After reading Jazz in...
2009-11-24
884 reads
SQL Server 2008: Table-valued parameters
A new feature of SQL Server 2008 is Table-valued parameters (TVP). This feature will allow Developers and DBAs to pass...
2009-11-24
822 reads
SQL Server 2008: Table-valued parameters
A new feature of SQL Server 2008 is Table-valued parameters (TVP). This feature will allow Developers and DBAs to pass...
2009-11-24
1,597 reads
Balancing Time Today v Time Tomorrow
I’ve always thought that you should invest where you can. Make a little effort now that will pay back later,...
2009-11-24
744 reads
Opening Doors – Part 2
Yesterday in Part 1 I wrote about opening doors – the art of showing others what is possible within the context...
2009-11-23
539 reads
Some Intel Westmere Benchmarks
PCLab.pl has an interesting review and benchmarks of a 3.07GHz Westmere-EP processor (which is the six-core, 32nm successor to the...
2009-11-23
991 reads
Replication Scripts: Show All Transactional Publications & Subscribers At Distributor
Anybody who has talked with me about replication or heard me present about it knows that I recommend using a...
2009-11-23
640 reads
Some Ways To Look For Things in SQL Server Modules
If you have a medium to large database in SQL Server, with lots of stored procedures, functions or views, it...
2009-11-23
513 reads
Blogs
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...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers