Helping MS Help Us
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.
2013-05-29
67 reads
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.
2013-05-29
67 reads
The fifth installment of the sp_Blitz script being run on the SQLServerCentral database server.
2013-05-29
6,993 reads
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.
2013-05-29
2,424 reads
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.
2013-05-29
3,470 reads
This post tells you how to change the QUOTED_IDENTIFIER and ANSI_NULLS settings of a database objects using Powershell.
2013-05-28
2,805 reads
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.
2013-05-28 (first published: 2013-05-24)
1,620 reads
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.
2013-05-28
3,252 reads
Rodney Landrum on why many DBAs find it hard to ask for, and take, their due DBAcations.
2013-05-27
264 reads
When installing 2 SQL Server instances on a Windows Cluster, the installation program requires a Named Instance during the installation of the second node and a dynamic TCP port is created. How do you update the TCP port after the installation in a clustered environment for the named instance?
2013-05-27
4,419 reads
This is a landing page for the sample SQL Server databases we are aware of.
2013-05-24
8,403 reads
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
WhatsApp:0817866887 Jl. Mayjen HR. Muhammad No.17, Putat Gede, Kec. Sukomanunggal, Surabaya, Jawa Timur 60189
WhatsApp:0817866887 Jl. Pantai Indah Kapuk Utara I Blok F, Kamal Muara, Kecamatan Penjaringan, Jkt...
Jl. Cibinong City Center No.5 Ruko Blok A, Pakansari, Kec. Cibinong, Kabupaten Bogor, Jawa...
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers