Tags » Microsoft SQL Server

Intro to Auditing in SQL Server on SQL Shack

I had an article published yesterday on http://www.SQLShack.com.

Intro to Auditing in SQL Server.

It’s worth reading if I do say so myself. In it I go through several different methods for generating data that might be required by an auditor. 125 more words

Microsoft SQL Server

Passing 70-463 Implementing a Datawarehouse with Microsoft SQL Server – Module 3 –Creating SSIS Packages

Chapter 3 in the Microsoft Press Training Kit for Exam 70-463 is the first introduction to how to create a Integration Service package.

In the previous modules we talked about building a prober database, using the right technologies and terminologies to build the prober tables. 20 more words

Datawarehouse

Passing 70-463 Implementing a Datawarehouse with Microsoft SQL Server – Module 2 – Implementing a datawarehouse

This module describes the basic topics of how to create a prober database and prober tables for a datawarehouse.

Key topics are

Datawarehouse

SQL Sat #325 - Arquivos, Demos e Feedback

Pessoal, bom dia.

Como alguns sabem, participei do evento SQL Saturday #325 que aconteceu no dia 27/09/2014 na Unip do Tatuapé. O que dizer sobre o evento? 342 more words

Pessoal

Database default locations

One of the options you had when installing your instance was setting some default file locations.

  • Defaut data file location
  • Default log file location
  • Default backup file location…
  • 641 more words
Microsoft SQL Server

Taking control of the 'sa' account for SQL Server 2012

As a DBA, it is perfectly normal to forget your password from time to time. No need to hold your breath or panic. In case of emergency that you need to recall your password or the ‘sa’ password, no need to panic because you can do it via the backdoor any way. 187 more words

SQL