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
6 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,707 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,477 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,887 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,280 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,426 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,799 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,689 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,611 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,517 reads
Forgive me for the title. Mentally I’m 12. When I started my current day...
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Hi! I've been banging my head against the wall for 2 days now trying...
Comments posted to this topic are about the item The Power of Data and...
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers