2011-06-03
2,844 reads
Steve Jones
- Interests: yoga, reading, biking, snowboarding, volleyball
- Twitter: @way0utwest
- Website: https://www.voiceofthedba.com
- LinkedIn: https://www.linkedin.com/in/way0utwest
- Bluesky: way0utwest.bsky.social
- Threads: @way0utwest
Duplicate Identity Values?
Can you have duplicate values in a field with the identity property? Of course, and this does it.
DROP TABLE dbo.MyTable
CREATE...
2011-06-02
4,267 reads
Free BI Training in June
Free training from Pragmatic Works, Microsoft and SQLServerCentral. Learn about SSAS performance, SSIS Configurations, GIS in SSRS and more.
2011-06-02 (first published: 2011-05-27)
10,422 reads
2011-06-02
2,651 reads
The Care of Data
Security is a big concern with data, especially when there is another company involved. Steve Jones notes today that cloud vendors need to beef up their work in this area.
2011-06-01
506 reads
Identity Reseeding
I love the identity property. I use it in many of my tables, mostly because it gives me a fairly...
2011-05-31
2,432 reads
The Ad Hoc Change
Almost every DBA will be asked to change data in production at some point. Too often we don't have the tools to allow users to correct errors, but when you make changes, Steve Jones reminds you that you need to be careful and still have a process.
2011-05-31
238 reads
2011-05-31
2,083 reads
Better Writing from Hemingway
These are five rules for writing from Ernest Hemingway, which I like and recommend for use in your communications. Definitely...
2011-05-30
1,740 reads
2011-05-30
77 reads
Blogs
Walking Through a Planned Failover: SQL Server Availability Groups on Kubernetes
When building the sql-on-k8s-operator, I wanted to make sure it could handle both planned...
Reading SQL Server File Headers with DBCC FILEHEADER
I’ve been doing a deep dive into SQL Server on-disk structures lately, and one...
T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
Forums
The Vector Data Type
Comments posted to this topic are about the item The Vector Data Type
What Power BI DirectQuery does to your SQL Server (and how to fix it)
Comments posted to this topic are about the item What Power BI DirectQuery does...
The New OS Wars
Comments posted to this topic are about the item The New OS Wars
Question of the Day
The Vector Data Type
What is the vector data type in SQL Server?
See possible answers