The Ongoing Costs of Building Software
There are lots of costs to building your own software, which Steve Jones notes might not be what you want to spend over time.
Create, Alter, Drop and Execute SQL Server Stored Procedures
In this tip we look at some examples of how to get started with creating, modifying and deleting SQL Server stored procedures.
Why you Should Avoid Using the @@IDENTITY Function
Phil Factor demonstrates why SQL Prompt has a 'Best Practice' rule (BP010) that checks for use of the @@IDENTITY function, and suggests less error-prone ways to get the latest identity values used in a table.
20 Years of Compare
When we started SQLServerCentral, there were originally 7 of us. We all decided to "invest" $50 to get the site going. With this seed money, we paid for a VM that hosted both SQL Server and IIS. This was enough money to run the site for 6+ months, and we set about building an online […]
Database Build Blockers: Mutually Dependent Databases
Phil Factor demonstrates a clever way to create 's...
Hiding What You Shouldn’t See
In this week's SImple Talk editorial Kathi Kellenberger looks at data that should be hidden and how to get security right within your organization.
Enter data privacy. Exit SQL Server 2008.
SQL Server 2008 and SQL Server 2008 R2 are out of extended support as of July 2019, but the end of bug fixes, security updates and ongoing support has far-reaching data privacy implications, as James Boother from Microsoft Gold Partner, Coeo, explains
What is in My Database Backup File
The Microsoft SQL Server team has made it easy for you to retrieve the information in a backup file by using a couple of commands. Read on to learn more!
Too much information can be counter-productive
If you want to be an effective communicator focus on what your audience need to hear rather than what you want to say
Blogs
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...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
Forums
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...
Creating a Simple and Flexible Random Password Generator in SQL Server
Comments posted to this topic are about the item Creating a Simple and Flexible...
SQL Art, Part 3: Happy Easter Fun in SSMS
Comments posted to this topic are about the item SQL Art, Part 3: Happy...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers