SQL Authentication – Forcing Password Changes
When you create a SQL Server login (with SQL authentication), you have the option of enforcing password policies from Windows...
2011-10-03
6,210 reads
Blog Posts
SQL Bits 9
SQL Bits was great
It’s been two years or more that I’ve been invited to SQL Bits. Not by email, but...
2011-10-03
1,266 reads
SQL Server – Marking a stored procedure as system object
Marking a stored procedure as system object allows to run the procedure in a user database context. There are two...
2011-10-03
2,697 reads
SQL Server Database SUSPECT state
According to BOL , a database in SUSPECT state is : “At least the primary filegroup is suspect and may be damaged....
2011-10-03
1,197 reads
Using Configuration Tables in SSIS 2008/2005
SSIS packages are great ETL tools and can do just about anything you need in terms of ETL. Most organizations...
2011-10-03
1,258 reads
Want to browse the web faster?
In our day-to-day activities, browsing the web is one of the most important aspects of our job. Whether researching for...
2011-10-03
801 reads
An Informal Compendium of SSAS Errors, Part 3: Unresolved Errors
This is the second in a series of posts on some SQL Server Analysis Services (SSAS) errors for which there...
2011-10-02
1,798 reads
Dataset with Text or Stored Procedure
As most of you already know, Reporting Services reports make use of Datasets to get data. These Datasets can get...
2011-10-02
1,230 reads
Slides & Samples from my SQLbits sessions
As
I have announced in all of my sessions at the SQLbits conferences in Liverpool/UK,
you can find here the
Slides & Samples for...
2011-10-02
912 reads
SQL Saturday 85 Follow Up
Last weekend I travelled down to SQL Saturday 85 in Orlando, FL. Like all of the other events that I’ve...
2011-10-02
981 reads
Blogs
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers