Data Encryption and Decryption in SQL Server 2008:
'via Blog this'
jueves, 30 de mayo de 2013
Data Encryption and Decryption in SQL Server 2008
Data Encryption and Decryption in SQL Server 2008: "CREATE CERTIFICATE can also load a certificate from a file or assembly."
'via Blog this'
'via Blog this'
martes, 28 de mayo de 2013
SQL Server Code Deployment Best Practices
SQL Server Code Deployment Best Practices: "SQL Server Code Deployment Best Practices"
'via Blog this'
'via Blog this'
lunes, 27 de mayo de 2013
martes, 21 de mayo de 2013
jueves, 16 de mayo de 2013
The database 'model' is marked RESTORING and is in a state that does not allow recovery to be run.Could not create tempdb. You may not have enough disk space available. Free additional disk space by deleting other files on the tempdb drive - Karthick PK 's Blog - Site Home - MSDN Blogs
The database 'model' is marked RESTORING and is in a state that does not allow recovery to be run.Could not create tempdb. You may not have enough disk space available. Free additional disk space by deleting other files on the tempdb drive - Karthick PK 's Blog - Site Home - MSDN Blogs: "Start SQLServer with Traceflag 3608,3609,-c,-f"
'via Blog this'
'via Blog this'
miércoles, 15 de mayo de 2013
Part 2: Resource Governor CPU Demo on multiple CPUs - SQL Server SQLOS team blog - Site Home - TechNet Blogs
Part 2: Resource Governor CPU Demo on multiple CPUs - SQL Server SQLOS team blog - Site Home - TechNet Blogs: "select scheduler_id, cpu_id, status, is_online from sys.dm_os_schedulers"
'via Blog this'
'via Blog this'
martes, 14 de mayo de 2013
lunes, 13 de mayo de 2013
SQL Consolidation Planning and recommended practices - Team blog of MCS @ Middle East and Africa - Site Home - TechNet Blogs
SQL Consolidation Planning and recommended practices - Team blog of MCS @ Middle East and Africa - Site Home - TechNet Blogs: "Consolidation strategies
SQL server consolidation can be achieved mainly through one of the below strategies:
Virtualization: using a single physical machine to host multiple virtual machines (VMs) running Microsoft® SQL Server® data management software
Multiple Instances: using a single machine to host multiple SQL Server instances,
Multiple databases: using a single instance of SQL Server to host multiple databases
Each of these strategies has different advantages and disadvantages related to security and compliance requirements, high availability and disaster recovery requirements, resource management benefits, level of consolidation density, and manageability tradeoffs"
'via Blog this'
SQL server consolidation can be achieved mainly through one of the below strategies:
Virtualization: using a single physical machine to host multiple virtual machines (VMs) running Microsoft® SQL Server® data management software
Multiple Instances: using a single machine to host multiple SQL Server instances,
Multiple databases: using a single instance of SQL Server to host multiple databases
Each of these strategies has different advantages and disadvantages related to security and compliance requirements, high availability and disaster recovery requirements, resource management benefits, level of consolidation density, and manageability tradeoffs"
'via Blog this'
Resource Governor Workload Management Scenarios
Resource Governor Workload Management Scenarios: "Monitor the Resource Governor performance counters and query the DMVs that will return information about resource usage for a workload group."
'via Blog this'
'via Blog this'
domingo, 12 de mayo de 2013
Welcome to the World of SQLServer.........: Resource Governor: What, How to Configure and Monitor
Welcome to the World of SQLServer.........: Resource Governor: What, How to Configure and Monitor: "CREATE FUNCTION rgclassifier1() RETURNS SYSNAME
WITH SCHEMABINDING
AS
BEGIN
DECLARE @grp_name AS SYSNAME
IF (APP_NAME() = 'ME2ME')
SET @grp_Name = 'wrkgroupCritical'
ELSE if(App_name()='GKPRD')
set @grp_Name = 'wrkgroupCritical'
else if (App_name()='Kate_Audit')
set @grp_Name = 'wrkgroupCritical'
else
SET @grp_Name = 'wrkgroupNormal'
RETURN @grp_name
END;"
'via Blog this'
WITH SCHEMABINDING
AS
BEGIN
DECLARE @grp_name AS SYSNAME
IF (APP_NAME() = 'ME2ME')
SET @grp_Name = 'wrkgroupCritical'
ELSE if(App_name()='GKPRD')
set @grp_Name = 'wrkgroupCritical'
else if (App_name()='Kate_Audit')
set @grp_Name = 'wrkgroupCritical'
else
SET @grp_Name = 'wrkgroupNormal'
RETURN @grp_name
END;"
'via Blog this'
viernes, 10 de mayo de 2013
sql server 2008 - How to print out the query SQL text of a transaction by querying the "fn_dblog" or DBCC LOG('DataBaseName')? - Database Administrators Stack Exchange
miércoles, 8 de mayo de 2013
martes, 7 de mayo de 2013
lunes, 6 de mayo de 2013
Optimizing tempdb Performance
Optimizing tempdb Performance: "Note that a dual-core CPU is considered to be two CPUs."
'via Blog this'
'via Blog this'
miércoles, 1 de mayo de 2013
Sql Server 2005 – Twelve Tips For Optimizing Query Performance by Tony Wright | Business Application Development for Strategic Advantage Melbourne | Hazaa
Optimizing MERGE Statement Performance
Optimizing MERGE Statement Performance: "CREATE TABLE dbo.Stock (StockName nvarchar(50) PRIMARY KEY, Qty int CHECK (Qty > 0));
"
'via Blog this'
"
'via Blog this'
Suscribirse a:
Entradas (Atom)