Finding SQL Server views with (or without) a certain property
In this tip Aaron Bertrand uses SQL Server metadata queries to discover SQL Server views that have certain properties or use certain syntax.
Citizen Programmers
Steve Jones finds the Salesforce platform interesting and notes we have lots of "citizen programmers" doing work with data.
Cloud Identities versus Federated Identities in Office 365
Identities, the 'accounts' by which Cloud and Web users identify themselves, are tricky to manage, and tiresome for the users. Cloud services such as Office 365 have their main use in large organisations and so there have to be easy ways for system administrators to maintain them. Microsoft provide three alternative strategies; Cloud identities, Synced identities and federated identities. What is the differences between them, and which should you choose?
SQL Monitor Custom Metric: Excessive Virtual Log Files in Transaction Log
This metric picks up excessive counts of Virtual Log Files (VLF) in a transaction log that can lead to performance problems, including write performance, restore and recovery times. The ideal value for this metric should be less than 25; excessively high values (greater than 50) can cause high write times when writing to the transaction log.
SQL Server Survey
How do you use SQL Server, and how do you expect this to change next year? Fill in our survey, and enter a prize draw to win Amazon vouchers.
Lead and Lag Functions in SQL Server 2012
Arshad Ali discusses how to use CTE and the ranking function to access or query data from previous or subsequent rows. He also shows you how to leverage the LEAD and LAG analytics functions to achieve the same result without writing a self-join query using CTE and ranking function
Holiday Struggles
The sporadic schedule of a day or two a week this holiday season has been a struggle for Steve Jones.
SSRS - Report for Stored Procedure with Multiple Values Passed
You created a report that passed three separate values to a stored procedure, simply enough. However, now the user comes back and they want the ability to select multiple values for the report to return data against. Check out this article for a walk-through on how to handle this request.
The 2014 Tribal Awards - Nominations Open
Nominations open until December 10. The Tribal Awards are back and looking to recognize some of the great contributors to the SQL community. Nominations are now open for 11 different categories, but closing soon so make sure your user group, favorite twitter account, or person who's helped you the most this year is nominated.
Continuous Delivery for Databases: Microservices, Team Structures, and Conway's Law
Matthew Skelton proposes a way to enable database continuous delivery that isn’t as outlandish as it first appears. What can Conways Law and Microservices tell us about the future of databases and DBAs? Matthew shows us a glimpse.
Blogs
What Does It Mean to Make Data AI-Ready?
By James Serra
Making Data AI-Ready, Part 1 (This is the first article in a three-part series...
Using the Data API Builder–VS Live San Diego Resources
By Steve Jones
Thanks for attending my sessions. Resources below: Slides: Using Data API Builder GitHub repo: ...
Running a Local LLM On Your Laptop Resources
By Steve Jones
Thanks to everyone that attended my sessions at VS Live San Diego yesterday. It...
Forums
Alamat BCA KCP Summitmas Telp/Wa:0821-8200-203
Hub Cs 08218200203 Summitmas I, Jl. Jend. Sudirman kav 52-53 No.61-62 Lt. Dasar, RT.5/RW.3,...
Alamat BCA KCP Iskandar Muda II Telp:0821-8200-233
Telp/Wa 62 8218200233 Jalan Sultan Iskandar Muda No.78 RT.003/05, RT.10/RW.2, Kby. Lama Sel., Kec....
Alamat BCA KCP Bona Indah Telp/Wa:0821-8200-233
Hub Cs 08218200233 Plaza Bona Indah Jl. Karang Tengah Raya Blk B/12, RT.1/RW.6, Lb....
Question of the Day
The Disabled Index
I run this code on SQL Server 2022.
CREATE TABLE Drink
(
drinkid INT NOT NULL
CONSTRAINT DrinkPK PRIMARY KEY CLUSTERED,
drinkname VARCHAR(20),
rating NUMERIC(2, 1)
)
GO
INSERT INTO Drink
(
drinkid,
drinkname,
rating
)
VALUES
(1, 'Margarita', 4.5),
(2, 'Mojito', 4.3),
(3, 'Old Fashioned', 4.7),
(4, 'Martini', 4.4),
(5, 'Cosmopolitan', 4.2)
GO
ALTER INDEX drinkpk ON dbo.drink DISABLE
GO
SELECT * FROM dbo.Drink
GO
What is the result? See possible answers