Your application can have impeachable indexes and queries, but they won't help you if you can't get to your data because another application has it locked. That's why every DBA and developer must understand SQL Server concurrency and how to troubleshoot excessive blocking or deadlocking. Kalen Delaney's book is your guide.
2013-08-26
5,172 reads
When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works. An effective response to a crisis requires rapid decisions based on understanding its role in ensuring data integrity.
2013-08-26
7,162 reads
This book shows how to use of mixture of home-grown scripts, native SQL Server tools,
and tools from the Red Gate SQL Toolbelt, to successfully develop database applications in a team environment,
and make database development as similar as possible to "normal" development.
2013-08-26
4,746 reads
This is a PASS VC Webinar, taking place on August 28, 1PM EDT. Get interviewing tips from both sides of the desk. Based on Thomas LaRock's 10 Things blog posts, this presentation by both Thomas LaRock and Karen Lopez will give you valuable insight into the interviewing process and how to improve your chances of landing that next job.
2013-08-26
2,736 reads
If you need to start monitoring your SQL Server instances and database, and there are many good reasons to do so, Tony Davis gives you the eight essential steps to diagnosing problems quickly.
2013-08-26
5,456 reads
Join Grant Fritchey (SQL Server MVP) as he tackles the most common problems and pitfalls of database deployment. He will explain how you (and your team) can make your deployment process, faster, more efficient and most importantly less stressful!
2013-08-26 (first published: 2013-08-19)
4,472 reads
Power View is a new tool for intuitive ad hoc SQL Server reporting which provides an interactive data exploration, visualization, and presentation experience to the business users. But how do you create these Power View reports? Check out this tip to learn more.
2013-08-23
4,074 reads
2013-08-22
17,865 reads
SQL Saturday visits Salt Lake City on September 7 for a free day of SQL Server training and networking. SQL Saturday has partnered with with the Utah Hadoop User Group and Utah Geeks Events to create the Big Mountain Data Conference.
2013-08-22
308 reads
Microsoft Business Intelligence stack provides several tools for analyzing data from different perspectives, in different format and different ways. Power View is a new addition to this arsenal which provides intuitive ad hoc reporting capabilities for business users to provide an interactive data exploration, visualization, and presentation experience. But how does it work and how to get started with it?
2013-08-22
4,296 reads
By Steve Jones
I ran across this article recently (https://www.gatesnotes.com/meet-bill/source-code/reader/microsoft-original-source-code) and it has a great opening piece...
By Steve Jones
I’m in the UK today, having arrived this morning in London. Hopefully, by this...
I’m not trying to start up a debate whether you should use tabs or...
Hi there, Has anyone else had any trouble with Database Mail in Cumulative Update...
I have a script task that tries to execute a HTTP request, which seems...
Comments posted to this topic are about the item SQL Server 2025 Standard Developer...
If I use BASE4_ENCODE() in SQL Server 2025, is the output URL Safe by default?
See possible answers