Secure Coding
I was looking recently for some sort of guideline that would help me ensure that code was securely written. I...
2014-05-07
836 reads
Blog Posts
Size Matters: 2 Products to Accelerate SQL Traffic
I talked previously about network pipelines and how to get the most out of a fat network in the post...
2014-05-07
1,169 reads
Speaking at SQLBits 2014: PreCon on In-Memory OLTP and Security session
Sprecher auf der SQLBits 2014 zu In-Memory OLTP und Sicherheit
(DE)
Nachdem ich letztes Jahr das erste Mal als Teilnehmer auf...
2014-05-07
840 reads
SQLSaturday #308 Houston, TX Saturday May 10th
This will be the second SQLSaturday in Houston I have spoken at and I am excited about talking Execution Plans...
2014-05-07
456 reads
What’s Happening at the PASS Business Analytics Conference?
Watch below for live updates during the conference Stay tuned and you’ll find out what’s going on during this week...
2014-05-07
450 reads
Datatypes In Your Mind–Question Of The Day
My latest question Datatypes In Your Mind is live today and it’s generated quite the discussion. I wrote here about...
2014-05-06
469 reads
Filetable–Moving files programmatically
I’ve been playing with Filetable and I was asked an interesting question. Can I move files to a folder programmatically?
It’s...
2014-05-06
1,823 reads
Using a Filtered Index to Enforce Filtered Uniqueness
One of the advantages and uses of Filtered Indexes (introduced with SQL Server 2008) is to provide filtered uniqueness. Obviously...
2014-05-06 (first published: 2014-04-24)
2,157 reads
VMworld 2014 Session Voting Is Open!
I can’t believe it’s that time of year again. VMware has opened up the public voting for the VMworld 2014...
2014-05-06
731 reads
Applied SQL: Orphan a user, fix orphaned users (sp_FixOrphanedUsers)
Ever heard of orphaned users? It’s a database user account, disconnected from its associated login. You typically get this when...
2014-05-05
927 reads
Blogs
The Book of Redgate: Get the right stuff done
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
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,...
Forums
Introduction of OPTIMIZE_FOR_SEQUENTIAL_KEY = ON
Hi, We have low latency high volume system. I have a table having 3...
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
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?