Dynamically name report/file export in SSRS
Wouldn't it be nice if you could have the report's name and filename be changed to something more specifically related to the particular run of that report.
Rolling Back a Restore
Should rolling back a restore be an option for SQL Server? Steve Jones talks about the possibilities in today's editorial and where it might come in handy.
Configure Windows Firewall for SQL Server 2008 Database Engine in Windows Server 2008 R2
I have installed SQL Server 2008 Developer Edition on Windows Server 2008 R2 and I am unable to get connect to SQL Server 2008 Instance from SQL Server 2008 Management Studio which is installed on another remote server. As I am new to Windows Server 2008 R2 it would be great if you can let me know the step by step approach to enable the default port of SQL Server 2008 in Windows Firewall for user connectivity.
TSQL Challenge 26 - Identify weekly schedule of training programs by course, classroom and timing
Here is another scheduling problem that deals with the allotment of classrooms for various training programs. Your chalenge is to read the source data and build an output result set that shows the weekly schedule of each training topic and the class room in which training is scheduled.
Finding Training
This Friday's poll looks at training where Steve Jones asks how you might convince your boss to pay for training, or what advice you'd give to others.
SQL Server 2008 T-SQL Enhancements Part - III
Continuing with his series on T-SQL enhancements in SQL Server 2008, Arshad Ali brings us a look at the HierarchyID and Large UDTs.
Microsoft SQL Server identify I/O bottlenecks
You can also identify I/O bottlenecks by examining the latch waits. These latch waits account for the physical I/O waits...
SSIS Packages - the Simplest Way to Create Them
Martin Policht delves deeper into the specifics of SQL Server 2008 and 2008 R2's Integration Services by presenting the most straightforward method of creating SSIS packages using Import and Export Wizard.
Thoughts on SQL Server Certification
This is probably part 1 of a series, but no guarantees.
Why Certify?
I've been working with SQL Server for 10 years...
Should We Lead or Follow?
Microsoft used to lead the way and teach us about their products. But it seems that perhaps the tide is turning and they are looking for us to lead them. Steve Jones has a few thoughts on the topic.
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
What is the Cloud?
Comments posted to this topic are about the item What is the Cloud?
Changing the Schema
Comments posted to this topic are about the item Changing the Schema
Index Fragmentation Explained: Page Splits, Logical Reads, and What to Do
Comments posted to this topic are about the item Index Fragmentation Explained: Page Splits,...
Question of the Day
Changing the Schema
I set up a few users on my SQL Server 2022 instance.
CREATE LOGIN User1 WITH PASSWORD = 'Demo12#1' CREATE USER User1 FOR LOGIN User1 GO CREATE LOGIN User2 WITH PASSWORD = 'Demo12#2' CREATE USER User2 FOR LOGIN User2 GO CREATE LOGIN User3 WITH PASSWORD = 'Demo12#3' CREATE USER User3 FOR LOGIN User3 GOI then created a schema that one of them owned. Under this schema, I added a table with some data.
CREATE SCHEMA MySchema AUTHORIZATION User1
GO
CREATE TABLE Myschema.MyTable(myid INT)
GO
INSERT MySchema.MyTable
(
myid
)
VALUES
(1), (2), (3)
GO
SELECT * FROM MySchema.MyTable
GO
I granted rights and verified that User2 could access this table.
GRANT SELECT ON Myschema.MyTable TO User2 GO SETUSER 'USER2' GO SELECT * FROM MySchema.MyTable GOThis worked. Now, I move this schema to a new user.
ALTER AUTHORIZATION ON SCHEMA::Myschema TO User3; GOWhat happens with this code?
SETUSER 'USER2' GO SELECT * FROM MySchema.MyTable GOSee possible answers