SQLCLR: Good? Or Evil? #MemeMonday
Is SQLCLR good or evil? Thomas LaRock (Blog | @SQLRockstar) is asking that question this month in his #MemeMonday blog party.
Let’s...
2012-04-10
1,140 reads
SQL Database roles and members
Q. How can I obtain the members of a role within a database?
A. One method is to use sp_helprolemember
EXEC mydatabase.dbo.sp_helprolemember
--returns...
2012-04-10
974 reads
Why I can not connect sql server ???
Recently, I installed sql server 2012 on windows 7 laptop, today when I wanted to login sql server with TCP/IP, I got...
2012-04-10
6,436 reads
April #Meme15 Assignment
Before the advent of the modern “Social Network”, many of us were already connected through tools that had much less...
2012-04-09
837 reads
SSIS How-To: Reuse Existing Connection Manager to Execute SQL in Script Task
There’s a myriad of examples out there on how to execute a sql task via OLEDB connections and C# in a...
2012-04-09
3,301 reads
Enabling Contained Databases in SQL Server 2012
One of the new features in SQL Server 2012 is the Partially Contained Database feature. I gave a talk on...
2012-04-09
2,844 reads
Onward and Upward!
As you may have heard by now, I am joining the wonderful team at SQLskills as a Principal Consultant starting...
2012-04-09
1,027 reads
SQL Saturday #107 in Houston, TX
SQL Saturday #107 in Houston, TX
Houston Skyline
SQL Saturday #107 in Houston, TX is almost here. I will be leaving for...
2012-04-09
1,621 reads
SSAS development quick tip
When creating a new cube in SSAS, you are frequently making changes that cause the whole cube to reprocess when...
2012-04-09
1,967 reads
Thoughts on Twitter
We hear a lot about social media these days: Facebook, LinkedIn, Google+, Twitter, etc. More and more, we’re expected to...
2012-04-09
977 reads
Blogs
Why AI isn’t paying off yet, and what to invest in first
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
Flyway Tips: Analytics Platforms (Snowflake and Databricks)
By Steve Jones
I’m really excited about some growth in Flyway support. I’ve been asking about this...
Paginated Reporting at Scale: Choosing the Right Microsoft Platform
By Rayis Imayev
"I've seen things you people wouldn't believe..."— Roy Batty, Nexus-6 Replicant, Blade Runner (1982)(2026-Nov-08) Yep,...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Table Partitioning in SQL Server: A Practical Guide to Managing Very Large Tables (VLDBs)
Comments posted to this topic are about the item Table Partitioning in SQL Server:...
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers