|
||||||
|
Backups? What are you talking about? One of the most basic administrative tasks in SQL Server is maintaining proper backups. A backup is nothing more than a dump of all the data, metadata and objects on a database (like stored procedures, functions, etc.) Not only do you need to make sure that backups of your DBs [...] Ideally, you want to go with Windows Authentication for all your users in SQL Server whenever possible. In the real world, most applications rely on SQL logins. So it happens rather frequently that when the password for a SQL login that is critical to an application is changed, that application breaks. Now, granted, if you are doing things [...] Ah, the nuisances of AD and Kerberos. Whenever you change the service account on a SQL instance, you need to make sure that an SPN pointing to the SQL instance is in place for the Service Account. Otherwise, you might get the dreaded “cannot generate sspi context” error. To manage SPNs registered on your service [...] If you want to do transactional replication, all the tables in the publication need to have a primary key. Here’s a quick way to determine which tables have a primary key. This is the query for SQL 2005 and 2008: SELECT so.name AS TableName, OBJECTPROPERTY(so.object_id, ‘TableHasPrimaryKey’) AS HasPrimaryKey And here is the query [...] Ok. First post. Let’s see how this goes. So they’re called ‘Startup Options’ or ‘Startup Parameters’ interchangeably. I have no idea why. In this post, I intend to show you how to change these programatically (with a script). The example is restricted to one of the many Startup Options that SQL Server accepts. Here’s the scenario. You [...] |
||||||
|
Copyright © 2010 SQL Server, SQLPS, and Life - All Rights Reserved 255 queries. 0.750 seconds. |
||||||
Recent Comments