Custom TDS Endpoints: Listening on multiple ports
Last time, I talked about how clients communicate with SQL Server through TDS endpoints and how to disable endpoints to...
2012-04-18
2,197 reads
SQL Injection Tools
I wouldn’t recommend you use any of the tools in this article for attacking anyone, but they could help you...
2012-04-18
1,245 reads
Professional Productivity Books
Just as with the "soft skills" books, in my professional development presentation, I list the professional productivity books that I have found most helpful in my...
2012-04-18
920 reads
PASS Data Arch VC presents Mike Fal: Eating the Elephant: SQL Server Table Partitioning
Thursday’s (May 17th, 2012) PASS Data Architecture Virtual Chapter has Mike demonstrating some cool Table Partitioning scripts which I was...
2012-04-18
570 reads
Listing SQL Instances on a machine (or list of machines)
TweetG’day,
Recently I was updating some of my Powershell scripts for managing SQL SERVER instances.
Generally, when writing a Powershell script to...
2012-04-17
5,766 reads
Backup Database Object
I saw this question in one of forums on backing up i.e. scripting out a database object. The problem is...
2012-04-17
1,844 reads
Merge Command In Sql Server
Merge Command:- Merge command is a new feature introduced in the SQL Server 2008. It can perform Update, Insert and...
2012-04-17
1,761 reads
Next up: #SQLSat107, HOU (and #SQLRally)
For me, conference season begins with the new year, and ends with the PASS Summit (sorry, November and December SQL...
2012-04-17
690 reads
Windows Server 2012
Microsoft’s Corporate Vice President Brad Anderson announced today at the Microsoft Management Summit 2012 in Las Vegas that the next...
2012-04-17
1,029 reads
Oracle Tips for MSBI Devs #2: Keyword compare between Oracle and SQL Server
While attending a recent Windows Azure Quick Start, the presenter, Mike Benkovich (@mbenko) happened to show a table on his...
2012-04-17
603 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