Up Your Value
With the economy in a recession, how should you be managing your career? Steve Jones talks a little about building your brand and showing value to your employer.
2009-03-04
118 reads
Articles
Up Your Value
With the economy in a recession, how should you be managing your career? Steve Jones talks a little about building your brand and showing value to your employer.
2009-03-04
223 reads
Up Your Value
With the economy in a recession, how should you be managing your career? Steve Jones talks a little about building your brand and showing value to your employer.
2009-03-04
184 reads
Creating and Modifying Tables in SSMS - SQL School Video
Learn how to use the SSMS GUI to modify tables in this SQL School video.
2009-03-03
3,069 reads
Adoption
Are lots of people adopting SQL Server 2008? Should you be looking at it? Steve Jones has a few comments on what the new lifecycle of SQL Server might mean for DBAs and developers.
2009-03-03
551 reads
Adoption
Are lots of people adopting SQL Server 2008? Should you be looking at it? Steve Jones has a few comments on what the new lifecycle of SQL Server might mean for DBAs and developers.
2009-03-03
559 reads
Adoption
Are lots of people adopting SQL Server 2008? Should you be looking at it? Steve Jones has a few comments on what the new lifecycle of SQL Server might mean for DBAs and developers.
2009-03-03
758 reads
Mapping Database Principals to Server Principals
A question on the forum asked how to find all the database mappings for a particular login. If you're on SQL Server 2000 or below, the tables you want to use are syslogins in the master database and sysusers in each database.
2009-03-03
4,468 reads
SQL Server Encryption Key Management between Development, Test and Production Environments
The company I work for has decided to use the encryption technology available in SQL Server 2005. We have almost everything ironed out except for which keys to use in the development, testing, and production environments. Should we use one key for all three environments or different keys for each?
2009-03-03
2,865 reads
The Safe and Easy Way to Delete All Data in a SQL Server DB
Deleting all the data in a SQL Server database doesn't have to involve complex code. The undocumented stored procedure sp_MSForEachTable safely bypasses built-in limitations to accomplish this common task.
2009-03-03
4,786 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