Over 800 SQL Server Professionals took part in the State of SQL Server Monitoring survey. Providing insights into how they monitor their SQL Server estates, the technologies they work with, what their biggest challenges are, and what the future trends for the industry are likely to be. For the detailed analysis of the responses, download your free copy of the report.
You are never too experienced to make mistakes. An occasional dose of humble pie serves as a reminder to up our game.
Just one day between a holiday and a weekend, so Steve asks for the ways you escape work this summer.
In this tip we will take a look at a SQL Server function that you can use to read the SQL Server transaction log to see what entries are made for database transactions.
Learn how you can execute multiple scripts in a restrictive database environment that doesn't allow any third-party tools.
If you’ve got a great idea for transforming software development or IT processes in your organization, but you’re not sure how to get buy-in from key stakeholders, or how to change your company culture check out this free webinar featuring Ike Ellis, Data Platform MVP! In this session, Ike will draw on his experience as a consultant and leader in software development to give you real-world tips to define, shape, and share your pitch successfully.
Compare common approaches to provisioning test data to database development teams, and assess how they stack up in terms of delivering realistic test data, managing bottlenecks, and meeting data privacy regulations.
Today, more organisations are adopting DevOps over older, traditional practices. In this article, Robert Sheldon explains DevOps and compares it to Waterfall and Agile methodologies.
Reading tutorials is fine. Shipping something is better. If you are trying to break...
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Comments posted to this topic are about the item Liability for AI Errors
Hello , I would like to run a stored procedure on a secondary replica...
Comments posted to this topic are about the item Pro SQL Server Internals
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers