Have you ever heard this question? The database refresh has gone from 10-15 minutes to 1.5 hours. Nothing has changed on the application server and the consultant said ask the DBAs to check the database server. Where do you start to find the problem? Check out this tip to learn more.
With a huge increase in the number of online learning frameworks, Dave Convery wonders how comfortable people are with this new way of polishing their skills.
Today Steve Jones looks at the way software affects the world and how we might be worried about how things might change in the future.
How to get an SSRS user's AD group membership in order to filter report content
Despite all the advances in software tools, there seem to be several enduring truths about software development. By understaning these 'laws', Ziv’s law, Humphrey’s Law and Conway’s Law for example, you can remove some of the mystery of the process. Al Noel discusses these and other laws that seem to apply generally to the art of programming.
Join us for a free day of SQL Server Training on June 8, 2013. There's also a Friday Preconference Training Day with Jonathan Kehayias and Joseph Sack.
Learn how to load data in an XML file into a table in SQL Server.
Tomorrow is the bicentennial SQL Saturday event. SQL Saturday #200 takes place in Philadelphia, and Steve Jones has some thoughts as he travels to the City of Brotherly Love.
Any queries run against SQL Server or Oracle databases are recorded, along with how many times those queries were run and how long they took. That information is shown alongside your .NET code, so you can quickly see why the code you wrote resulted in those queries being executed. This can be particularly powerful if you’re using ORMs like Entity Framework to access data, which tend to be an impenetrable black box where performance issues can arise, but where it’s difficult to understand why.
We're looking for scripts that you use in your daily job to find, fix, and solve issues in your environment.
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Efficient query performance in Amazon Redshift often comes down to how well you manage...
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
If you are looking for India’s best FSSAI Third Party Auditing Services in India....
If you are looking for India’s best FSSAI Third Party Auditing Services in India....
Recently, our dev teams approach me for advice on improving their huge heap table...
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers