Obfuscation
Test data is critical to being sure your application works, but is production data ok to use in test environments?
SQLServerCentral Rules of Conduct
Being a part of the community means that there are certain standards that we'd like you to adhere to. Steve Jones brings you a few reminders of how to behave when posting in the community.
XML Workshop XIII - XSD And Variable Content Containers
Continuing on with his highly popular XML series, Jacob Sebastian looks at variable content and stylesheets in your SQL content.
RAID Scaling Charts, Part 3: 4-128 kB Stripes Compared
This is the third article that deals with analyzing the various possibilities involving various RAID setups and differing numbers of hard drives. We used the same hard disks again here: eight Samsung HM321KJ SATA/300 drives powered all of the possible RAID 0, RAID 5 and RAID 6 setups, with from three to as many as eight hard drives configured to use stripe sizes of 4 to 128 kB.
Serve SQL Data in XML Format
Ivan Pepelnjak describes a few ways to extract data from SQL databases and serve it to an AJAX application running in a web browser.
Data Ownership
Who owns the data that we generate ourselves? It's not as easy to answer that as you think.
Login creation in SQL Server 2005 for SQL Server Authentication Mode
Its a graphical representation of login creation in SQL Server 2005 for SQL Server Authentication Mode.
Usages of CONTEXT_INFO
How many of you have ever used SET CONTEXT_INFO in your SQL Server applications? Chances are it is not something you have been exposed to, but new author Yousef Ekhtiari brings us an example of how this particular construct can be used in your application.
RAID Scaling Charts, Part 2: RAID 5 And RAID 6
For our RAID tests, we once again use Samsung HM321KJ SATA/300 drives. This time, we benchmarked RAID 5 and RAID 6 setups with three to eight hard drives.
Using the DATE data type in SQL Server 2008
In SQL Server 2008 we get a new DATE date type that allows you to store a date without a time.
Blogs
Introducing the SQL Server on Kubernetes Operator
Are you considering replatforming your SQL Server workload due to recent vendor changes, but...
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Forums
Removing TDE
Comments posted to this topic are about the item Removing TDE
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Analysis Services Model w/ Direct Query and (Default Veritpaq)
Analysis Services (either the integrated workspace in Power BI or on a SQL Server)...
Question of the Day
Removing TDE
How do I remove TDE encryption of data from database xxx?
See possible answers