And now for a completely inappropriate use of SQL Server
A while back I wrote up a short introductory overview of Genetic Algorithms. Just for the shear, absolute fun of...
Emailing tempdb Query Results to Paul Randal with PowerShell
I was referred to someone on twitter today who wants to email query results without setting up database mail. I...
Monitoring Transactional Replication – The Distribution Queue
This article looks at the distribution database what information can be obtained for monitoring transactional replication.
SQL Saturday #69 - Philadelphia
SQL Saturday comes back to Philly on Mar 5, 2011. Spread the word and come get a free day of training on SQL Server.
Odd Questions
Interviews can be strange for many reasons, often because interviewers are not well prepared to evaluate candidates. This Friday Steve Jones asks you what weird things you might have encountered in an interview when someone is asking you questions.
Automatic Statistics Update Slows Down SQL Server 2005
I have a database which has several tables that have very heavy write operations. These table are very large and some are over a hundred gigabytes. I noticed performance of this database is getting slower and after some investigation we suspect that the Auto Update Statistics function is causing a performance degradation.
Drive
What motivates people? What makes them happy at their jobs? Steve Jones talks about Drive, the book by Dan Pink, and the possibility that people actually like doing their jobs and are willing to work.
Renumbering Rows in a Table Variable (or Table/Temp Table)
I was recently working on a data cleanup problem where I had to do lots of comparisons of one row...
Top 10 Transact-SQL Statements a SQL Server DBA Should Know
Microsoft SQL Server is a feature rich database management system product, with an enormous number of T-SQL commands. With each feature supporting its own list of commands, it can be difficult to remember them all. MAK shares his top 10 T-SQL statements that a DBA should know.
Commuting Pain
Did you know that commuting can actually affect your health? Steve Jones talks about an IBM study on this and suggests you talk to your boss about telecommuting or remote work. The option to do so just might be beneficial for your long term health.
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
Cs Lion Air Tower Tlp/ Chat 083843888827
Cs Lion WhatsApp 083843888827 Sunset Road 100 C,Simpang Siur Kuta, Jimbaran, Kec. Kuta Sel.,...
BCA KCU KALIMALANG Telpon/WA:08213111185
BCA KCU KALIMALANG Telpon/WA:08213111185 Jl. Tarum Barat Blk. E No.5, Wil. Kota, Kec. Duren...
Cs Lion Air Tower Tlp/ Chat 083843888827
Layanan bantuan Refund dana reschedule booking tiket Cs Lion Air WhatsApp 083843888827 layanan online...
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