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
Basit Aalishan Masood-Al-Farooq
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,695 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,468 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,881 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,269 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,417 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,790 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,675 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,600 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,431 reads
Blogs
AI Step 1
By Vinay Thakur
As this is an Artificial Intelligence (AI) World, things are changing. We can see that...
Beginner’s Guide: Building a Dockerized Todo App with React, Chakra UI, and Rust for Backend
In a containerized app, React and Chakra UI provide a robust and accessible user...
A New Word: Nachlophobia
By Steve Jones
nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...
Forums
Call dynamic sql storedprocedure from SSIS execute sql task
hi, I have a table called Rules Create table Rules ( Id int ,...
Migrating database with many orphan users.
I am currently upgrading a very old database running SQL Server 2008 to SQL...
Active and Active Cluster
Hi Team, I am planning to apply security updates for SQL Server 2016 on...
Question of the Day
The Funny SELECTs
What is returned from this query?
SELECT
( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2011' AND soh.OrderDate < '01/01/2012') AS OrdersIn2011
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2012' AND soh.OrderDate < '01/01/2013') AS OrdersIn2012
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2013' AND soh.OrderDate < '01/01/2014') AS OrdersIn2013; See possible answers