SSIS: Value does not Fall Within the Expected Range
Every now and again I find myself working with SSIS for one reason or another. Every now and again I find myself fighting with SSIS because it provides less...
2014-07-17
50 reads
SSIS: Value does not Fall Within the Expected Range
Every now and again I find myself working with SSIS for one reason or another. Every now and again I...
2014-07-25 (first published: 2014-07-17)
32,403 reads
Quick Tips–SQL Prompt Aliases for Every Table
I love SQL Prompt, and think it’s a great productivity tool. Even before I worked at Red Gate, I love...
2014-07-24 (first published: 2014-07-17)
9,806 reads
SSC Editorial: Access Disdain
Contrary to the title (by design), Access Disdain is about not automatically hating Access (or it’s users). Clearly Access has...
2014-07-17
626 reads
How to Check SQL Server Installation Date Time ?
You need to run the following query and it will give you the date of your SQL Server Installation. SELECT @@SERVERNAME SERVERNAME, CREATE_DATE ‘INSTALALTIONDATE’ FROM SYS.SERVER_PRINCIPALS WHERE SID =...
2014-07-17
23 reads
Get SQL Server Info - Quick Tip & Script
There
are a number of ways to collect basic information about SQL Server, its
version, edition and other top-level properties. What is...
2014-07-22 (first published: 2014-07-17)
11,343 reads
Modeling the Agile Data Warehouse with Data Vault – Review
A few months ago I followed an introductory course about the data vault modeling technique for data warehouses at a...
2014-07-17
1,756 reads
How to Check SQL Server Installation Date Time ?
You need to run the following query and it will give you the date of your SQL Server Installation.
SELECT @@SERVERNAME...
2014-07-17
1,888 reads
Goodbye Microsoft, Hello New Adventure
About two months ago, after two and a half years, I left Microsoft.
Microsoft is an amazing place to work for. It’s...
2014-07-17
480 reads
5 Tips for Finding SQL Server System Data
Regardless of the type of development (application or reporting) that you are performing on SQL Server. There are 5 items...
2014-07-23 (first published: 2014-07-17)
9,751 reads
Blogs
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
Forums
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
The End of Summer
Comments posted to this topic are about the item The End of Summer
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers