My articles published on SSWUG.org from March 2014 to July 2014
The following is the list of my articles published on SSWUG.org from March 2014 to July 2014. To read these...
2014-08-08
855 reads
The following is the list of my articles published on SSWUG.org from March 2014 to July 2014. To read these...
2014-08-08
855 reads
I am very happy to announce that my first book “SQL Server 2014 Development Essentials” has now been published by...
2014-07-28
1,693 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,465 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,875 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,264 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,414 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,782 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,670 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,596 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,379 reads
By Steve Jones
the standard blues– n. the dispiriting awareness that the twists and turns of your...
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
In a previous blog post we went through how to build a Docker container...
I'm tracing activity on one database and would like to include the client_app_name in...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers