Don Kiely contends that exercising administrative rights over our computers is a major cause of insecure systems. In the first of five articles, he explains the concept of "least privilege" and shows why software developers should be happy to operate as "mere users."
2005-09-08
2,801 reads
If you run PowerChute 6.x on any of your servers, be very careful of patching and rebooting them. You might end up with more downtime and problems than you expected.
2005-08-18
4,347 reads
Most skilled professionals—be they butchers, bakers or software makers—take pride in selecting their own tools of the trade. Why is it then that developers and DBAs in large corporations often are not afforded the same professional courtesy or opportunity? The tools they use are just as vital to their livelihood, yet when it comes to high-cost software, developers and DBAs often have no input into what is purchased for their use.
2005-07-29
2,572 reads
Just a little older than SQLServerCentral.com, SQLTeam.com has been another great community for SQL Server developers. A look back from Bill Granazio
2005-07-26
1,913 reads
Judging by mainstream news coverage over the past few weeks, the issue of data theft, particularly loss of backup tapes, has reached the tipping point. It might mean that your relatively anonymous existence within your company could come to a screeching halt.
A look at how encrpytion might be if importance to your company.
2005-07-12
2,583 reads
J.D. Edwards was big on Systems Thinking, a way of looking at your systems and improving their functions. It was applied it to IT to become one of the top IT organizations to work for. Read some of these articles for an overview of how this works.
2004-09-24
2,685 reads
In 2004 is the IT industry expanding or contracting? Is your job secure? Steve Jones recently completed a survey and just got the results. Read this short summary of the results.
2004-09-03
5,148 reads
The SQL Server ports 1433, was blocked recently by an ISP. New Author Denny Figuerres read our release and decided to bring you some comments about why this isn't such a bad idea. Read on and see if you agree that blocking the SQL Server ports shouldn't present you any problems.
2004-06-18
9,266 reads
It's not often that we toot our horn, but SQLServerCentral.com was chosen as the feature site by GotDotNet.com, one of Microsoft's premier .Net sites. Check it out!
2004-06-03
1,250 reads
A little off topic (or is it?), David needed to vent a little - something we can all appreciate. Meant to be light hearted fun, please don't take too seriously.
2004-04-19
10,843 reads
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Hello team Can anyone share popular azure SQL DBA certification exam code? and your...
Comments posted to this topic are about the item Faster Data Engineering with Python...
Comments posted to this topic are about the item Which Result II
I have this code in SQL Server 2022:
CREATE SCHEMA etl;
GO
CREATE TABLE etl.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT etl.product
VALUES
(2, 'Bee AI Wearable');
GO
CREATE TABLE dbo.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT dbo.product
VALUES
(1, 'Spiral College-ruled Notebook');
GO
CREATE OR ALTER PROCEDURE etl.GettheProduct
AS
BEGIN
exec('SELECT ProductName FROM product;')
END;
GO
When I execute this code as a user whose default schema is dbo and has rights to the tables and proc, what is returned? See possible answers