There isn't a lot of acceptance of Azure from DBAs. Steve Jones talks about some of the advantages of Azure and thinks that we should be working to ensure that our internal systems respond at the same speed as people can get from Azure.
In this tip Aaron Bertrand describes some of the ways in which you can extend the DDL trigger functionality.
The Microsoft Connect system allows many of us to submit feedback, but is Microsoft doing anything with it? Join us and place your vote on some items and try to influence Microsoft.
The fifth installment of the sp_Blitz script being run on the SQLServerCentral database server.
Databases often need more than just the database objects to run. There may be certain server objects and components, and SQL Agent objects, that are required as well. For an automated deployment, these need to be identified and their build script placed in source control. They then need to be deployed via the pre, or post deployment script. Phil spells out how and why.
This custom metric adds Brent Ozar's popular SP_Blitz scripts to Red Gate SQL Monitor. It looks for configuration, security, health and performance problems, and reports back with a list of issues for you to look into. It’s great for quickly understanding the state of a server you've been asked to look after.
This post tells you how to change the QUOTED_IDENTIFIER and ANSI_NULLS settings of a database objects using Powershell.
Data and software will impact our lives more and more in the future. Steve Jones talks about some of the potential ways in which both of these have changed the world.
Red Gate Software is bringing SQL in the City, the popular free training event, back to the US in three new cities. This October, the events will take place in Pasadena, Atlanta and Charlotte.
One way of getting the advantages of the Cloud without having to migrate the entire database is to just maintain a copy of the data that needs to be accessible to internet-based users in Windows Azure SQL Database. There are various ways of keeping the two in sync, and Feodor Georgiev describes a solution based in using SSIS.
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Comments posted to this topic are about the item Pro SQL Server Internals
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Comments posted to this topic are about the item Running SQLCMD II
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