Monday, November 9, 2015

Extracting SSRS Report RDL (XML) from the ReportServer database « Bret Stateham's Blog

Extracting SSRS Report RDL (XML) from the ReportServer database « Bret Stateham's Blog
Posted by

Friday, September 18, 2015

Identity Columns: Are You Nearing The Limits? SQL Fool

Identity Columns: Are You Nearing The Limits? SQL Fool
Posted by

SQL Server - Generate Index Script

SQL Server - Generate Index Script
Posted by

Thursday, September 17, 2015

A SQL Server DBA myth a day: (30/30) backup myths - Paul S. Randal

A SQL Server DBA myth a day: (30/30) backup myths - Paul S. Randal
Posted by

Oracle Apps DBA stuff: BIGFILE Type Tablespaces Versus SMALLFILE Type

Oracle Apps DBA stuff: BIGFILE Type Tablespaces Versus SMALLFILE Type
Posted by

Wednesday, September 16, 2015

Less Than Dot - Blog - What To Do When Your Identity Column Maxes Out

Less Than Dot - Blog - What To Do When Your Identity Column Maxes Out
Posted by

Monday, September 14, 2015

Service Broker Advanced Basics Workbench

Service Broker Advanced Basics Workbench
Posted by

Friday, August 28, 2015

INSTR - Find Position in String - Oracle to SQL Server Migration - SQLines

INSTR - Find Position in String - Oracle to SQL Server Migration - SQLines
Posted by

Tuesday, August 25, 2015

Saving the contents of a SQL Server XML column to a file - Bob Beauchemin

Saving the contents of a SQL Server XML column to a file - Bob Beauchemin
Posted by

Saving the contents of a SQL Server XML column to a file - Bob Beauchemin

Saving the contents of a SQL Server XML column to a file - Bob Beauchemin
Posted by

Configure Service Broker in SQL Server 2012 Nirav's Diary

Configure Service Broker in SQL Server 2012 Nirav's Diary
Posted by

Saving the contents of a SQL Server XML column to a file - Bob Beauchemin

Saving the contents of a SQL Server XML column to a file - Bob Beauchemin
Posted by

Friday, August 7, 2015

Joords Oracle DBA blog: Disable the automatic startup of the Oracle Clusterware (CRS|HAS) software

Joords Oracle DBA blog: Disable the automatic startup of the Oracle Clusterware (CRS|HAS) software
Posted by

Thursday, July 30, 2015

Oracle DBA - sharing an experience: Resuming failed or stopped Data Pump Import execution

Oracle DBA - sharing an experience: Resuming failed or stopped Data Pump Import execution
Posted by

Friday, May 29, 2015

http://edvaldocastro.com/sql-server-2016-ctp2-e-hora-de-estudar-ficadica/
Posted by

Tuesday, April 28, 2015

Recover from unusable dictionary indexes in 10g using 11g | ORA600

Recover from unusable dictionary indexes in 10g using 11g | ORA600
Posted by

Configure SQL Server Security to Allow Only Browsing of SSIS Packages

Configure SQL Server Security to Allow Only Browsing of SSIS Packages
Posted by

Wednesday, April 22, 2015

Granting access SSIS to non-admin users

Posted by

Thursday, April 16, 2015

10 most important SQL Server transaction log myths - SQL Shack - articles about database auditing, server performance, data recovery, and more

10 most important SQL Server transaction log myths - SQL Shack - articles about database auditing, server performance, data recovery, and more
Posted by

Thursday, April 9, 2015

Troubleshooting SQL Server issues with sys.dm_os_performance_counters - SQL Shack - articles about database auditing, server performance, data recovery, and more

Troubleshooting SQL Server issues with sys.dm_os_performance_counters - SQL Shack - articles about database auditing, server performance, data recovery, and more
Posted by

Sys.dm_os_performance_counters Demystified | Simple SQL Server

Sys.dm_os_performance_counters Demystified | Simple SQL Server
Posted by

Script to Find and Drop All Orphaned Users in All SQL Server Databases

Script to Find and Drop All Orphaned Users in All SQL Server Databases
Posted by

Tuesday, March 31, 2015

Script to Find and Drop All Orphaned Users in All SQL Server Databases

Script to Find and Drop All Orphaned Users in All SQL Server Databases
Posted by

Script to Drop All Orphaned SQL Server Database Users

Script to Drop All Orphaned SQL Server Database Users
Posted by

Thursday, March 26, 2015

Top 10 SQL Server Counters for Monitoring SQL Server Performance — DatabaseJournal.com

Top 10 SQL Server Counters for Monitoring SQL Server Performance — DatabaseJournal.com
Posted by

Monday, March 2, 2015

Collecting Performance Data into a SQL Server Table

Collecting Performance Data into a SQL Server Table
Posted by

Friday, February 27, 2015

How to Find Unused Statistics - Turgay Sahtiyan - Senior SQL Server PFE - Site Home - MSDN Blogs

How to Find Unused Statistics - Turgay Sahtiyan - Senior SQL Server PFE - Site Home - MSDN Blogs
Posted by

Monday, February 2, 2015

Collecting Performance Data into a SQL Server Table

Collecting Performance Data into a SQL Server Table
Posted by

How to Prove Your SQL Server Needs More Memory [Video] - Brent Ozar Unlimited® by Brent Ozar Unlimited®

How to Prove Your SQL Server Needs More Memory [Video] - Brent Ozar Unlimited® by Brent Ozar Unlimited®
Posted by

Top 10 SQL Server Integration Services Best Practices - Microsoft SQL Server Development Customer Advisory Team - Site Home - MSDN Blogs

Top 10 SQL Server Integration Services Best Practices - Microsoft SQL Server Development Customer Advisory Team - Site Home - MSDN Blogs
Posted by

Reporting Services Performance and Optimization - Microsoft SQL Server Development Customer Advisory Team - Site Home - MSDN Blogs

Reporting Services Performance and Optimization - Microsoft SQL Server Development Customer Advisory Team - Site Home - MSDN Blogs
Posted by

Wednesday, January 7, 2015

The default trace in SQL Server - the power of performance and security auditing

The default trace in SQL Server - the power of performance and security auditing
Posted by

Monday, January 5, 2015

Using Optimizer_WhatIF and StatsStream to Simulate a Production Environment

Using Optimizer_WhatIF and StatsStream to Simulate a Production Environment
Posted by
Subscribe to: Posts (Atom)