DBCC AUDITEVENT - SQL Server Undocumented T-SQL Commands

DBCC AUDITEVENT - SQL Server Undocumented T-SQL Commands

SBS 2008 Monitoring Database grows too big #backup #sbs http://virginia.nef2.com/sbs-2008-monitoring-database-grows-too-big-backup-sbs/  # SBS 2008 Monitoring Database grows too big Yes – I had this happen on my SBS 2008 server myself. Instead of taking the normal route to try and resolve it however, I decided to mess with a few SQL commands and try to dig under the covers to see if I could delete data that was too old. I thought that this might allow me to reduce the content of the database…

SBS 2008 Monitoring Database grows too big #backup #sbs http://virginia.nef2.com/sbs-2008-monitoring-database-grows-too-big-backup-sbs/ # SBS 2008 Monitoring Database grows too big Yes – I had this happen on my SBS 2008 server myself. Instead of taking the normal route to try and resolve it however, I decided to mess with a few SQL commands and try to dig under the covers to see if I could delete data that was too old. I thought that this might allow me to reduce the content of the database…

How to Rebuild System Databases in SQL Server 2005 #system #restore #server # #r http://cameroon.nef2.com/how-to-rebuild-system-databases-in-sql-server-2005-system-restore-server-r/  How to Rebuild System Databases in SQL Server 2005 We need to rebuild the system databases if the master database is corrupted or damaged. Let us discuss in detail how to rebuild system databases in SQL server 2005. Step 1. Take a full backup of all the System and User databases prior to rebuilding the system…

How to Rebuild System Databases in SQL Server 2005 #system #restore #server # #r http://cameroon.nef2.com/how-to-rebuild-system-databases-in-sql-server-2005-system-restore-server-r/ How to Rebuild System Databases in SQL Server 2005 We need to rebuild the system databases if the master database is corrupted or damaged. Let us discuss in detail how to rebuild system databases in SQL server 2005. Step 1. Take a full backup of all the System and User databases prior to rebuilding the system…

Migrating a Database in Cloud Foundry #cloud #db http://malawi.remmont.com/migrating-a-database-in-cloud-foundry-cloud-db/  # Migrating a Database in Cloud Foundry Application development and maintenance often requires changing a database schema, known as migrating the database. This topic describes three ways to migrate a database on Cloud Foundry. You can also migrate a database by running a task with the Cloud Foundry Command Line Interface tool (cf CLI). For more information about…

Migrating a Database in Cloud Foundry #cloud #db http://malawi.remmont.com/migrating-a-database-in-cloud-foundry-cloud-db/ # Migrating a Database in Cloud Foundry Application development and maintenance often requires changing a database schema, known as migrating the database. This topic describes three ways to migrate a database on Cloud Foundry. You can also migrate a database by running a task with the Cloud Foundry Command Line Interface tool (cf CLI). For more information about…

13 Most Important SQL Commands Any Programmer Should Know

13 Most Important SQL Commands Any Programmer Should Know

How Do I #sql #restore #database http://maine.remmont.com/how-do-i-sql-restore-database/  # How Do I. Restore a SQL Server database to a new server? This blog entry is also available as a TechRepublic gallery and as a TechRepublic download . As a DBA, I have been in many situations where I had to move databases to a new server due to old hardware, failed hardware, failed drives, etc. You have two options you could use to carry out this task: SQL Server Management Studio (GUI) T-SQL (Command…

How Do I #sql #restore #database http://maine.remmont.com/how-do-i-sql-restore-database/ # How Do I. Restore a SQL Server database to a new server? This blog entry is also available as a TechRepublic gallery and as a TechRepublic download . As a DBA, I have been in many situations where I had to move databases to a new server due to old hardware, failed hardware, failed drives, etc. You have two options you could use to carry out this task: SQL Server Management Studio (GUI) T-SQL (Command…

List of SQL commands | Codecademy

List of SQL commands

List of SQL commands | Codecademy

Linked servers and distributed queries #list #of #sql #servers http://liberia.nef2.com/linked-servers-and-distributed-queries-list-of-sql-servers/  # Linked servers and distributed queries Linked servers allows to issue SQL commands against OLE DB providers. Because Microsoft also makes available an OLE DB Provider for ODBC Drivers , it is also possible to issue queries against a variety of ODBC drivers. With linked servers and distributed queries, you can query all sorts of data sources and…

Linked servers and distributed queries #list #of #sql #servers http://liberia.nef2.com/linked-servers-and-distributed-queries-list-of-sql-servers/ # Linked servers and distributed queries Linked servers allows to issue SQL commands against OLE DB providers. Because Microsoft also makes available an OLE DB Provider for ODBC Drivers , it is also possible to issue queries against a variety of ODBC drivers. With linked servers and distributed queries, you can query all sorts of data sources and…

Setup a Windows Azure Private Cloud – Stack Overflow #creating #a #cloud #server http://cheap.nef2.com/setup-a-windows-azure-private-cloud-stack-overflow-creating-a-cloud-server/  # I want to use Windows Azure. However, my admin guy is fighting against me using it. From my understanding, I can setup a private cloud so that I can use Azure’s features, but on an internal environment. I have convinced him to let me try it. I have one Windows Server 2008 server that I can try this out on…

Setup a Windows Azure Private Cloud – Stack Overflow #creating #a #cloud #server http://cheap.nef2.com/setup-a-windows-azure-private-cloud-stack-overflow-creating-a-cloud-server/ # I want to use Windows Azure. However, my admin guy is fighting against me using it. From my understanding, I can setup a private cloud so that I can use Azure’s features, but on an internal environment. I have convinced him to let me try it. I have one Windows Server 2008 server that I can try this out on…

Pinterest
Search