Join Red Gate for a free seminar on November 15 (the day before SQL Saturday Oregon). Steve Jones and Grant Fritchey, SQL Server MVPs, will present best practices for SQL Server version control, continuous integration and deployment, in addition to showing Red Gate tools in action.
This tip will guide you through a simple example to illustrate how you can use the SQL Server Distributed Replay feature to replay a simple SQL Server trace file that contained two sessions executing statements concurrently.
In which Phil Factor wonders why all the different cloud storage offerings are so different, sparse in their features, crude and incompatible
Today Steve Jones talks about the prospect of cyberwar and the potential impacts on corporate systems. Perhaps we ought to be building better, more secure software.
I demonstrate how to monitor and troubleshoot Service-Broker-task execution in the context of a database-maintenance process.
This metric counts the number of principals who are members of the sysadmin fixed server role. SQL Server relies on role-based security to manage permissions. If multiple IT system administrators have permissions to set up new SQL Server logins, they might be inclined to do so as part of the sysadmin role. Adding a normal user to the sysadmin role could pose a security risk and is not recommended unless the principal is highly trusted.
Maybe the best way of helping the busy database professional to get started with practical PowerShell-based administration is to pull together all the essential community cmdlets into a toolkit for the POSH DBA, and explain how and why you'd use them.
SQL Server MVP Brian Kelley brings us a great new article that solves a problem that might help your security. In this short piece, we learn how we can use logon triggers to block users based on their IP address.
This Friday Steve Jones wants to know what do you want to learn more about in SQL Server? It's the end of the year, with lots of speakers winding down their events, but looking forward to next year. Let us know now what you'd like to learn about in 2014.
Sqlcmd makes many SQL Server tasks, such as automating test runs and maintenance tasks, easier and quicker. The sqlcmd command-line utility is valuable to any database developer or DBA as the prime means of executing batches of SQL Statements to SQL servers, and saving results to file. Rob Sheldon gives you the basic facts about this great utility.
The DBA life is fraught with pain. Those battles that we endure are mostly...
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
Wa:0821-4447-7715 PPCR+MQ6, Jl. Raya Darmo No.5, Keputran, Kec. Tegalsari, Surabaya, Jawa Timur 60265
Hello, I would like to ask whether it is technically possible to redirect a...
WA:08218154393 Jl. Brigjen Katamso No.183, Keparakan, Kec. Mergangsan, Kota Yogyakarta, Daerah Istimewa Yogyakarta 55121
Can I set Accelerated Database Recovery on tempdb?
See possible answers