Getting a job is hard. If you’ve been lucky enough not to struggle for a job, don’t make the mistake of thinking it will always be easy. Equally, finding a good job is harder still. Some more tips for you to consider: Leverage your recruiter. They know..
Disaster Recovery is always ranked by DBAs and managers as one of the most important things to have set up. Yet many people working with databases don't spend time on this. Steve Jones has a few comments from the news this week.
Part 4 of this series from Drew Salem shows how you build a report in Visual Studio.
Brad engages in a little Summer daydreaming, and wonders what the Ideal DBA job would look like...
Page compression is a new feature available in Enterprise and Developer editions of SQL Server 2008. In this article, MAK discusses how to enable PAGE data compression on a table and index.
Phil enjoys an old Microsoft Training manual and wonders why it is no longer possible to encompass the whole of SQL in a 400 page book any more..
In a recent blog post, see the steps Denny Cherry thinks are vital to monitoring both successful and unsuccessful outside user logins to your SQL Server.
Imagine you are invited to speak somewhere and you have a bit of power. Have some fun with this Friday's poll and let us know what you'd demand.
Use of event handlers provided in SSIS package to handle runtime errors while the package is running and logging the error information in the database.
Is there a way to identify which objects are dependent on other objects within a SQL Server database? I need to modify the table structure to add new columns. However, before making any changes I want to make sure that I understand all the object dependencies. Is there a way in SQL Server 2008 to quickly identify all the object dependencies?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item The Problem Isn't Always Your...
Comments posted to this topic are about the item Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers