Why I Run SQLServerCentral
After the holiday, Steve Jones gives a little insight into his job, and what he likes about running SQLServerCentral.
2009-12-01
102 reads
Editorials
Are You a Giver or a Taker?
A guest editorial from Brad McGehee today examines the way in which DBAs interact with the community. Do you take from the community, learning from others? Or do you give back more? Both are a part of many DBAs' careers. Brad talks about the importance of giving back when you can.
2009-11-30
66 reads
How Oslo can you go?
Some developers have reacted with dismay to the recent news that Microsoft’s Oslo project is being integrated into the SQL Server platform and renamed SQL Server Modeling. The overwhelming feeling seems to be that their DSL dream is being snatched away.
2009-11-30
93 reads
The DBA Boat
For a fun Friday poll, what type of SQL or database related name would you give to yourself or someone else? Steve Jones asks the question after someone sends an email about naming their new boat with a SQL name.
2009-11-27
78 reads
Happy Thanksgiving 2009
Happy Thanksgiving to everyone in the US. The editorial today has a blooper reel from the podcasts in celebration of the holiday.
2009-11-26
46 reads
Networking One Tweet at a Time
Maintaining a professional network can take some effort from you, but the modern social networking tools can help. Steve Jones talks about some of the benefits from keeping in touch with other professionals this way.
2009-11-25
53 reads
Limit Your Data Liability
We aren't necessarily liable for data breaches at our company, but will that last forever? Steve Jones talks about some things that you might want implement to ensure that you aren't liable if there ever is a security issue.
2009-11-24
52 reads
Communication Issues
When you have a team of people working together to manage systems, communication becomes important. Steve Jones notes that a lack of working with each other and letting the rest of the team know what you are doing can cause unnecessary work for others.
2009-11-23
106 reads
Planning your 2010 Professional Development
Brad suggests some tips on how to maximize your professional development in 2010. Get a plan together now, and you'll make your life a lot easier.
2009-11-23
213 reads
Just SQL Auth
Would you like to have only SQL Server Authentication on your instances? That's the subject of this Friday's poll.
2009-11-20
85 reads
Blogs
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers