The following is the list of my articles published on SSWUG.org from March 2014 to July 2014. To read these articles, you must have SSWUG.org standard-level membership. SQL Server...
2014-08-08
I am very happy to announce that my first book “SQL Server 2014 Development Essentials” has now been published by...
2014-07-28
1,704 reads
An SQL Server Integration Services package often includes tasks that can take a long time to run. If the package...
2014-05-30
1,272 reads
You can use an HTTP endpoint to allow access to data over HTTP and Secure Sockets Layer (HTTPS) without needing...
2014-05-30
1,422 reads
You use a join to combine data from different tables into a single result set. Joins most commonly use foreign...
2014-05-30
1,606 reads
In this article, you will learn about database design concepts. The database design concepts discussed in this article focus almost...
2014-05-30
1,685 reads
As part of the planning and research before implementing new SQL Server, you must determine the amount of space needed...
2014-05-30
4,884 reads
You can send e-mail from within stored procedures, functions, and triggers by using SQL Server Database Mail. You can also...
2014-05-30
1,475 reads
Management tools play a vital role in enterprise database management. This is because the well-integrated tools extend the administrator’s capabilities,...
2014-05-30
2,795 reads
Problem
You are trying to drop a database user, but are getting the following error message:
The database principal owns a schema...
2014-05-29
2,504 reads
By Steve Jones
Don’t reserve your kindest praise for a person until their eulogy. Tell them while...
I wanted to try out the new JSON index which is for the moment...
By Brian Kelley
I thought it would be good to put my thoughts down on how to...
Comments posted to this topic are about the item Learning a New Language
Hi, we have a few people who like to experiment on our prod sql...
Comments posted to this topic are about the item Guidelines and Requirements
If I use DBCC CLONEDATABASE, can I remove some of the information from the copy?
See possible answers