32 bit SSIS in 64 bit environment
This article provides a solution to executes 32 bit SSIS packages in 64 bit environment.
2013-10-14
7,389 reads
Articles
2013-10-14
1,036 reads
Introduction to SQL Server 2014 CTP1 Memory-Optimized Tables
There are a number of new features that became available with SQL Server 2014. One of the more exciting features is the new Memory-Optimized tables. In this article Greg Larson explores how to create Memory-Optimized tables, and what he's found during his initial exploration of using this new type of table.
2013-10-14
3,725 reads
Networking at the PASS Summit: First timers
The PASS Summit is just over a week away, and one again Andy Warren and I are hosting a networking dinner on Monday night. This is a free, informal event to help people get to know each other. Whether you are new to the community or have been to many events, you’re welcome to attend.
2013-10-14 (first published: 2013-10-04)
1,371 reads
Execute As
Learn how you can use Execute As in a stored procedure to control permissions. This article includes an example that limits access to encryption routines for users.
2013-10-11 (first published: 2011-02-02)
18,349 reads
Red Gate to respond instantly to user requests at SQL in the City Charlotte and PASS 2013
Red Gate is shipping new features and fixes this week, based on requests from attendees at SQL in the City Charlotte and PASS Summit 2013.
2013-10-11
712 reads
Getting Started with Columnstore Index in SQL Server 2014 – Part 1
Column Store Index, which improves performance of data warehouse queries several folds, was first introduced in SQL Server 2012. In this article series Arshad Ali talks about how you can get started with using enhanced columnstore index features in SQL Server 2014 and do some performance tests to understand the benefits.
2013-10-11
3,531 reads
Day 327: From Prototype to Production
In November of 2012, I embarked on a Quixotic attempt at building a BI prototype in 7 days. I dubbed the experiment ‘OLAP Sprint’...
2013-10-10
2,572 reads
SQL Saturday #237 - Charlotte
The Charlotte BI Group (CBIG) is excited to bring the 2nd annual SQL Saturday, BI Edition, to Charlotte on October 19. This SQL Saturday training event is focused on Microsoft Business Intelligence, Analytics, and Data Administration topics.
2013-10-10
406 reads
When SQL Server Nonclustered Indexes Are Faster Than Clustered Indexes
SQL Server Clustered indexes can have enormous implications for performance of operations on a table. But are there times when a SQL Server non-clustered index would perform better than a clustered index for the same operation? Are there any trade-offs to consider? Check out this tip to learn more.
2013-10-10
6,323 reads
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
How do I explain that SQL Server should not be used as a code repository?
This week my BI Developer colleague proudly showed me a new Power BI report...
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers