Inspiring Change
Day 2 at the PASS Summit provides some inspiration for Steve Jones at the Women in Technology luncheon.
2014-03-25 (first published: 2009-11-05)
158 reads
Day 2 at the PASS Summit provides some inspiration for Steve Jones at the Women in Technology luncheon.
2014-03-25 (first published: 2009-11-05)
158 reads
Schemas may be largely irrelevant to small databases, where it is no trouble to assign permissions to individual objects, but they are vital for a hard working corporate database that is being actively developed and used by several applications, with thousands of objects that must be assigned the correct permission.
2014-03-24
237 reads
Testing our applications is important, but at what level do we need to test? Steve Jones talks about unit testing today, and wonders if this is prevalent for SQL Server developers.
2014-03-24 (first published: 2009-11-10)
555 reads
Much of the data collected by companies is being sold for profit. This data isn't treated well and while not much may change, perhaps we should be aware of how we handle data as professionals.
2014-03-20
113 reads
2014-03-19
482 reads
Many people have been unsure of cloud computing and what it means for your particular application. Steve Jones notes there's a great new demo that can help you get started exploring the Azure offerings.
2014-03-17
194 reads
How many passwords do you have? Steve Jones has a lot and while he notes there are some new ways for us to authorize ourselves for servers, they aren't necessarily making things more secure or less complex.
2014-03-17
152 reads
What do you do as a DBA if you get asked to cook the books? With the economy doing poorly, some executives will be tempted to mis-report earnings and they might ask the technical people to help. Steve Jones has a few thoughts.
2014-03-14 (first published: 2009-09-03)
357 reads
The #sqlhelp hashtag on Twitter is a great way to interact with the SQL Server community and get help.
2014-03-13
262 reads
SQL Server is so large and complex that it's like an operating system. In fact, there the core engine is often referred to as the "SQL OS" by Microsoft developers. Steve Jones would like to see SQL Server as it's own OS at some point.
2014-03-12 (first published: 2009-08-26)
559 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, true)
GO
See possible answers