From where does SSMS get its database defaults?
We can create a database simply by typing in the command createdatabase DB1
We don’t have to provide any other...
2014-04-25 (first published: 2014-04-16)
2,367 reads
Blog Posts
Out for a day
I’m hoping I’m only out for a day. As I write this, I’ll be recovering from my ACL surgery, though...
2014-04-25
642 reads
Powershell Goodies
If you haven’t seen some of the other blog post, or the Microsoft Powershell Blog, Microsoft recently release Script Browser for...
2014-04-25
1,679 reads
Reblog: April 18 to April 24
Photo credit – JStove
Old posts are like unicorns. You might see them just once, but it’d sure be nice to have...
2014-04-25
1,323 reads
Why does my Failover Cluster Instance Keep Failing Back and Forth?
A few months ago I was paged by a client because their SQL Server Failover Cluster Instance (FCI) was experiencing...
2014-04-25 (first published: 2014-04-17)
8,116 reads
Another Question Of the Day
Yesterday I submitted a new question of the day based on the best idea generator you can find – something that...
2014-04-24
561 reads
Journey of an On-Premises DB to Azure VM – SQL Server 2014 makes it easier!
SQL Server 2014 is deeply integrated with Windows Microsoft Azure and moving an On-prem database to a Microsoft Azure VM...
2014-04-24 (first published: 2014-04-16)
1,948 reads
Microsoft Azure Automation
Microsoft just announced a new mechanism for managing your Azure resources, Automation. You can check out the documentation on it...
2014-04-24 (first published: 2014-04-16)
1,780 reads
Techfuse, a New Laptop, and How Microsoft Azure Helped Save the Day
On Tuesday, April 22, I had the opportunity to speak at the Techfuse conference in Minneapolis. I was presenting a...
2014-04-24
681 reads
Azure Automation
I introduced Azure Automation in a previous post. I’ve spent some more time exploring it.
There’s a set of documentation available...
2014-04-23
1,377 reads
Blogs
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Getting Your Data GenAI-Ready: The Next Stage of Data Maturity
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Forums
The Long Name
Comments posted to this topic are about the item The Long Name
Eight Minutes
Comments posted to this topic are about the item Eight Minutes
T-SQL in SQL Server 2025: Fuzzy String Search I
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
The Long Name
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?