Database uplevel Restores
Today I've been reading Paul Randal's collection of Blogs from a series called A SQL Server DBA myth a day....
2012-01-06
695 reads
Are you allowed to use social networking at Work?
I was reading this article about internet usage by staff who work for local authorities in Wales http://www.bbc.co.uk/news/uk-wales-16394916 The content...
2012-01-06
970 reads
Arithmetic overflow error and isdate sql
Executing a t-sql statement with a convert function
convert(datetime, my_date_column) ,
threw an arithmetical overflow error with the message :
Message
Arithmetic overflow...
2012-01-06
1,264 reads
A Tale of Two Cities - SQLSaturday Goes Global..
It was a day of warm weather, it was a day of cold weather. A tale of two cities on...
2012-01-06
2,064 reads
SQL Server 2012 Licensing VMs without SA
I ran across a blog talking about Microsoft licensing, and found it very interesting. I learned a few things, and...
2012-01-06
2,009 reads
31 Days of SSIS in a PDF
At some point last year after finishing the 31 Days of SSIS, I decided to bundle up all of the posts...
2012-01-09 (first published: 2012-01-05)
7,136 reads
PASS Summit Eval – Extended Events
As I mentioned in yesterday’s post, I had two sessions at the PASS Summit this past year in which I...
2012-01-05
753 reads
The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered.
You may fire up the SharePoint 2010 Management Shell (which allows you to run PowerShell commands to do cool SharePoint...
2012-01-05
2,254 reads
Msg 7395: Unable to start a nested transaction
Happy new year, SQL peeps! I hope everyone had a wonderful holiday. Last week was very quiet at work, but...
2012-01-05
3,393 reads
LOOP, HASH and MERGE Join Types
Today I’ll talk about the available JOIN operator types in SQL Server (Nested Loops, Hash and Merge Joins), their differences,...
2012-01-05
5,895 reads
Blogs
How I Built RAG for My Accounting App on Bedrock and pgvector
The first version of my accounting assistant could not find a single purchase of...
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...
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