The Query’s goal is :
Find the top 5 Locations
List the users who live in those top 5 Locations, alphabetized by their DisplayName
There are a LOT of ways I could write this query, but for the purpose of this post, I’m only going to contrast common table expressions (CTEs) versus temp tables:
We’re talking about a relatively … Read More →
In this article (Italian), we have already discussed Continuous Integration and DLM. We described the main reasons for putting a database under source control and for testing our databases. In this article, we are going to discuss a real scenario of SQL Server unit testing with the tSQLt framework.
What Is Unit Testing
In computer programming, unit … Read More →
Apprendre le SQL
Le SQL (Structured Query Language) est un langage permettant de communiquer avec une base de données. Ce langage informatique est notamment très utilisé par les développeurs web pour communiquer avec les données d’un site web. SQL.sh recense des cours de SQL et des explications sur les principales commandes pour lire, insérer, modifier et … Read More →
The page is dedicated to presentations, scripts, and other resources that are available for download.
SQL Server Audit - Evidence Never Lies - PowerPoint slide deck
SQL Saturday #692 - Atlanta, GA - Jul 15, 2017
SQL Saturday #610 - Richmond, VA - Mar 18, 2017
SQL Saturday #592 - Raleigh, NC - Mar 11, 2017
Policy Based Management - Beyond the Basics … Read More →
Free SQL Server video tutorial
Connecting to SQL Server
Working with databases
Creating and working with tables
Cascading referential integrity
Retrieving identity column value
Unique key constraint
All about select statement
Different ways to replace NULL
Union and Union All
Stored Procedures with output parameters
Difference between output … Read More →
Minimum No. of tables
1:1 cardinality with partial participation of both entities
1:1 cardinality with total participation of atleast 1 entity
Note: This is a general observation. Special cases need to be taken care. We may need extra table if attribute of a relationship can’t be moved to any entity side.
Keys of a relation: There are … Read More →
What are advantages of DBMS over traditional file based systems?
Ans: Database management systems were developed to handle the following dif?culties of typical ?le-processing systems supported by conventional operating systems.
1. Data redundancy and inconsistency
2. Dif?culty in accessing data
3. Data isolation – multiple ?les and formats
4. Integrity problems
5. Atomicity of updates
6. Concurrent access by multiple users
7. Security … Read More →
Beginning back with SQL Server® 2005, Microsoft® integrated the .NET runtime into the database engine. This runtime engine is called the SQL Server Common Language Runtime (CLR), and is commonly referred to as SQLCLR. SQL Server CLR enables you to extend the capabilities of the SQL Server database engine with the rich programming environment of … Read More →
These are custom tasks and tools.
Transfer Packages Sample Application 3 Sep 2002
SQLDTS.com Article: Transferring DTS Packages
DTS ActiveX Helper 26 Apr 2005
A simple COM component which wraps the GetExecutionErrorInfo method using variant types for returning data, compatible with ActiveX Script Tasks. Full source code included (VB6).
SQLDTS FTP … Read More →
One of the things that has always bugged me about DTS is how difficult it was to transfer the DTS packages from SQL Server to structured storage (aka a file on the disk). In Yukon, DTS packages are always stored as files but in SQL Server 2000 they are stored in SQL Server by default. … Read More →
An easy way to script, document and backup all SQL Agent job using Powershell. The script will create a SQL job called "Backup SQL Agent Jobs" which will script all job and save the script in the specified location.
Code source of article : http://www.dbascript.com/script-all-sql-agent-jobs-using-powershell
Use this Stored Procedur for create script from all job in one database :
And for all DataBase in SQL Server use this Stored Procedure
Maintain files of sql for each table then use cygwin to run a shell script that cats them together then run it on the server.
Code source of this article : https://stackoverflow.com/questions/3361163/automatically-create-scripts-for-all-sql-server-jobs
I recently had to look at a problem that required converting the column values from a set of rows into a single comma separated string. On the face of it this is quite straightforward, but as with many things SQL Server there is more than one way to solve the problem. I’ve presented a few … Read More →
So now I have to resort to doing web service calls the old way, making post requests using MSXML. This is what my stored procedure looks like.
Cet article décrit les éléments suivants concernant cette version du correctif :
Les problèmes qui sont résolus par le package de correctifs
Les conditions préalables à l’installation du package de correctifs
Si vous devez redémarrer l’ordinateur après avoir installé le package de correctifs
Si le package de correctifs est remplacé par un autre package de correctif logiciel
Si vous devez modifier … Read More →
code source : http://sqlfiddle.com/#!3/210df/2
One common requirement is to create an XML structure that is based on the schema of an existing table. Let’s assume that we’ve received a request to create XML data from relevant fields in the Person.Person table, for the person having BusinessEntityID 10001. We need to gather the values from this row:
We need to … Read More →
One of the most common jokes you’ll hear when talking about the most important tasks for a Database Administrator goes like this – a DBA needs one of two things, a good backup or a good resume. It’s true. If you’re not doing backups, and ensuring that you can recover databases from those backups, you’re … Read More →
Table of Contents
Help! I’m lost!
But I don’t want to use the Brian Keller VM!
I already have MS RM set-up. What’s the minimal work I need to do to add a DB to my system?
Exercise 1 – Source Controlling your Database
Linking a Database to source-control
Exercise 2 – Getting your Database into the Continuous Integration Process
Part … Read More →