BIDS Helper 1.6 for SQL Server 2012 released
BIDS helper is Visual Studio add-in with features that extend and enhance the functionality of the SQL Server 2005 and SQL Server...
2012-03-30
2,528 reads
James Serra's Blog
TinyInt problem in SSAS
If you have a source table that has a Tinyint primary key column defined as IDENTITY and you create a...
2012-03-28
1,604 reads
SQL Server Parallel Data Warehouse (PDW) Appliance Update 3 (AU3)
In the next few weeks there will be an update to the SQL Server Parallel Data Warehouse (PDW) called “Appliance Update 3?...
2012-03-26
2,047 reads
Dell Quickstart Data Warehouse Appliance for SQL Server 2012
As a follow-up to my blog Microsoft SQL Server Reference Architecture and Appliances, Dell recently announced the future availability of Dell Quickstart...
2012-03-23
1,305 reads
Fast Track for SQL Server 2012
When the Fast Track Data Warehouse 3.0 Reference Guide was published, it was based off of SQL Server 2008 R2....
2012-03-21
963 reads
SQL Server 2012: xVelocity
After SQL Server 2012 was released this past week, I saw a few mentions from Microsoft about a new feature...
2012-03-19
1,187 reads
SQL Server 2012: New Certification Info
As a follow-up to my posts SQL Server “Denali”: New Certifications and SQL Server 2012: New Certifications, there are now final details coming...
2012-03-16
1,929 reads
SQL Server 2012: Tabular Models vs PowerPivot Models
In SQL Server 2012, there is a new data model, called tabular, that is part of the new feature called the...
2012-03-14
2,766 reads
Houston Area SQL Server User Group Presentation
Thanks to everyone who attended my presentation “Scaling SQL Server to HUNDREDS of Terabytes” at HASSUG.
Here is the PowerPoint presentation: Scaling SQL...
2012-03-13
707 reads
Data Warehouse Architecture – Kimball and Inmon methodologies
What is the best methodology to use when creating a data warehouse? Well, first off, let’s discuss some of the reasons why...
2012-03-15 (first published: 2012-03-12)
9,512 reads
Blogs
Inspecting TSQL Abstract Syntax Trees
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
Becoming a creator, my website experience
By DataOnWheels
Over the past few months, I have debated starting a new blog to discuss...
T-SQL Tuesday #192 Invitation: SQL Server 2025 Excitement
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
Forums
Collecting active node hostname at centralized location
So folks we have around 30/40 sql server failover cluster insatnce with each having...
Beginner in sql server
Hello, How to add a UNIX_TIMESTAMP at my publish_date please CREATE TABLE [dbo].[latest_info]( [id]...
fast farward curson vs while loop on @table
hi, need to known weather fast farwand cursor is faster than a while loop...
Question of the Day
Getting the Indexed Columns
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers