The Predictioneer
I’m not sure how this book got on my radar, but it turned out to be fairly interesting. It’s written...
2010-01-28
811 reads
Blog Posts
What the Exec?
I’ve been working with SQL Server for 10 years and have worked in production with versions 6.5 – 2005 and used...
2010-01-28
672 reads
Cleaning up sys.dm_exec_cached_plans
Following on from my previous post in which I noticed that SQLServer itself was artificially bloating sys.dm_exec_cached_plans, the next obvious...
2010-01-27
1,124 reads
Handling Escape Sequences in SSIS Expression String Literals
The SSIS expression language is a powerful tool for a developer that gives you one method of making a package...
2010-01-27
8,432 reads
Handling Escape Sequences in SSIS Expression String Literals
The SSIS expression language is a powerful tool for a developer that gives you one method of making a package...
2010-01-27
992 reads
Identity Values – Dropouts and Spaces
Identity values are very useful, but there can be misconceptions about the way in which they work. One of the...
2010-01-27
996 reads
Lenovo W510
I finally ordered a new laptop, a Lenovo W510, that caught my eye. I was thinking the T series 510,...
2010-01-27
937 reads
Speaking at the Baltimore SQL Server User Group
On Monday, the first of February, 2010, I will be speaking at the Baltimore SQL Server User Group meeting at...
2010-01-27
488 reads
SQL Saturday #34
The event is this Saturday. Take a look at our sponsors, speakers and the program. It’s going to be a...
2010-01-27
590 reads
Wildcards in WHERE Clauses
This is just a very short post regarding the use of wildcards in a WHERE Clause
It is possible that the...
2010-01-27
591 reads
Blogs
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Creating a Simple and Flexible Random Password Generator in SQL Server
Comments posted to this topic are about the item Creating a Simple and Flexible...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers