Up or out? Deciding on SQL Server scalability
Scalability is the ability of a system to support an increased workload by adding incremental system resources without fundamentally changing...
2013-08-06
565 reads
Blog Posts
Why use a SSAS cube?
What are the advantages of using SSAS Cubes over a regular data warehouse for reporting? Note I’m not asking why...
2013-08-06
1,669 reads
Windows Phone Security Advisory - Weakness in Security Protocol
If you're using a Windows phone, versions 7.8 or 8, there is a new security advisory out with respect to...
2013-08-06
626 reads
August 2013 – Monthly SQL Server Checklist
I can’t believe it’s already August. I had planned to get to the lake more this year, spend more time...
2013-08-05
589 reads
Be Cautious Offering Guidance
Guidance is hard.
Seriously, you’d think it would be easy. You’d think you say things like, don’t shrink your database, most...
2013-08-05
2,328 reads
Best Practices to Deliver BI Solutions Presentation
I will be presenting a brand new session entitled “Best Practices to Deliver BI Solutions” tomorrow, August 6th, at 11am...
2013-08-05
832 reads
Continue Package Execution After Error in SSIS
When it comes to ETL, I’m a pessimist. Until proven otherwise, I assume that all data is bad, all connections...
2013-08-05
2,055 reads
Custom Navigation controls in SharePoint 2010
There are several ways to create a custom navigation control in SharePoint. In the below image you can see the...
2013-08-05
941 reads
Database Permissions Queries
Over the last year of blogging my thoughts and queries I’ve discovered something interesting. I posted Where is my Backup?...
2013-08-05
1,442 reads
Embedding Flash Video in a Blog Post
I recently needed to figure out how to embed Flash streaming video in a blog post. LiveWriter does Youtube ok...
2013-08-05
576 reads
Blogs
Accept the no and move on
By Brian Kelley
Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin....
Don’t Fight with AI
By Steve Jones
I was recently trying to handle a simple task with a few AI tools...
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Forums
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers