The purpose of this blog post is to help you identify the four possible parts of a SQL Server...
What Are the Four-Part Names of a SQL Server Object?
read more
Results for "SQL Query"
Five Tips for Query Designer
In my previous blog post, Query Designer in SQL Server Management Studio (SSMS), I showed you how...
Query Designer in SSMS
As a Microsoft Endpoint Manager Configuration Manager (MEMCM / MECM/ SCCM / ConfigMgr)...
SQL Server Data Tools (SSDT) and RDL Versions
You built your report using SQL Server Data Tools (SSDT) which saves the RDL in the SQL Server...
How to Set SQL Server Integration Services (SSIS) Protection Levels
I’m using SQL Server Integration Services (SSIS) to clone a database. I’m doing this for a...
Error: 40 – Could Not Open a Connection to SQL Server
I’m working on a project to create a SQL Server reporting database; basically it’s a clone of the...
How to Install SQL Server Integration Services Tools
I’m working on a project to clone a SQL Server database (aka the ConfigMgr database) because a...
Why is SQL Server Indexing Important?
This is one of those questions where the answer should seem obvious to everyone. But it is...
How to Fix a Poorly Written WQL Query
What is a poorly written WQL query? This is a loaded question; you will get lots of answers from...
Query Formatting Tools
As many of you know I answer a lot of ConfigMgr query-related questions. One of my pet peeves is...
The Subselect Query
Earlier, in my blog posts from last week I talked about how queries are processed and how a Not...
v_GS_NETWORK_ADAPTER_CONFIGURATION verse v_Network_DATA_Serialized
While working on my article What is Parsename and 4 Part Version String?, I was looking at my IP...