Prevent SQL Logins from using SSMS … or any other app
In a continuation of my previous LOGON TRIGGER post.
A downside to SQL logins is that anyone with the username / password...
2011-06-18
2,126 reads
In a continuation of my previous LOGON TRIGGER post.
A downside to SQL logins is that anyone with the username / password...
2011-06-18
2,126 reads
Well today was the last day for a while I would be greeted by this sign:
It was a pretty exciting...
2011-06-18
831 reads
Altering a table using SQL Server Management Studio ( SSMS ) can be done by right clicking on the table and by...
2011-06-17
339 reads
I bought my E6500 almost three years ago, giving away what was a perfectly good Latitude to trade up to...
2011-06-17
557 reads
Why being careful is such an important mindset when working with SQL and databases.
At the Boston Public Schools, certain processes...
2011-06-17
1,127 reads
Not that you would know it from the page below, but Itzik Ben-Gan is back in London to do a...
2011-06-17
1,276 reads
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Oddly enough,...
2011-06-17
474 reads
Attention, southerners (or those who can find their way south)! There’s another great SQL Saturday event coming up in August...
2011-06-17
1,204 reads
“Gotta say it was a good day…”
-Ice Cube
On The SQL Saturday Circuit
I’ve been speaking at all the regional SQLSaturday events I...
2011-06-17
639 reads
A nice new little add-in available for SSMS on Codeplex. It helps with repetitive tasks involved with SSAS such as processing and deployment. ...
2011-06-17
1,061 reads
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
Dears, Hope this message finds you well I did not see in this foruns...
The below code works for backup files only from local drives. When replaced with...
I have been asked to fine-tune the following SQL that was written by a...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers