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
856 reads
Basit's SQL Server Tips
Book: SQL Server 2014 Development Essentials
I am very happy to announce that my first book “SQL Server 2014 Development Essentials” has now been published by...
2014-07-28
1,701 reads
Implementing Checkpoints – To restart SQL Server Integration Services packages from the point of failure
An SQL Server Integration Services package often includes tasks that can take a long time to run. If the package...
2014-05-30
1,270 reads
SQL Server 2005/2008/2008R2: HTTP endpoints
You can use an HTTP endpoint to allow access to data over HTTP and Secure Sockets Layer (HTTPS) without needing...
2014-05-30
1,421 reads
Types of Join in SQL Server
You use a join to combine data from different tables into a single result set. Joins most commonly use foreign...
2014-05-30
1,603 reads
SQL Server: Database Design Basics
In this article, you will learn about database design concepts. The database design concepts discussed in this article focus almost...
2014-05-30
1,679 reads
Database capacity planning and management
As part of the planning and research before implementing new SQL Server, you must determine the amount of space needed...
2014-05-30
4,882 reads
Configuring SQL Server Database Mail Feature
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,471 reads
SQL Server 2014 Management tools
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
The database principal owns a schema in the database, and cannot be dropped
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,489 reads
Blogs
Index Maintenance Can Change NORECOMPUTE Settings
By Steve Jones
I had a customer recently ask about a change in one of their constraints...
So You Think You Should Get a Radio
This is not database related, so if you’re not interested in hearing about something...
Speaking at SQL Saturday Austin 2025
By Steve Jones
SQL Saturday Austin 2025 is in just a few days. I am honored to...
Forums
fetch an execution plan from SQL Server's buffer cache
Comments posted to this topic are about the item fetch an execution plan from...
A way for the team to keep track of changes made
Is there a best practice way for the team to keep track of changes...
SQL Query Performance with Left Join
I have a query that is performing poorly It has a left join to...
Question of the Day
The Long Running Backup
I have a long running backup of the Sales database during a maintenance window that is going to take another 2 hours to complete on SQL Server 2022. I also need to perform some proactive work and add another file (ndf) to the Sales database to handle the expected growth of the next month. Can I do both simultaneously?
See possible answers