User access management on DB & object level
It will help to find and manage the users access on DB level
2018-07-05 (first published: 2018-06-26)
441 reads
Scripts
2018-06-15 (first published: 2018-01-04)
2,128 reads
Entering random data into a table
Este bloco de código tem o objetivo de demonstrar como podemos inserir um quantidade de linhas de registro de dados aleatórios de uma tabela no Microsoft SQL Server.
2018-06-14 (first published: 2018-06-12)
1,521 reads
2018-06-12 (first published: 2018-01-03)
2,007 reads
2018-06-11 (first published: 2018-01-03)
2,704 reads
2018-06-08 (first published: 2018-01-03)
2,564 reads
2018-06-07 (first published: 2018-01-13)
2,407 reads
2018-06-05 (first published: 2018-01-11)
2,220 reads
SQL Server Backup, Integrity Check, Index and Statistics Maintenance
Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016, and SQL Server 2017.
2018-06-04 (first published: 2008-02-23)
48,399 reads
Generate scripts for SQL Server Management Studio diagrams
The procedure generates an import script of diagrams.
2018-05-31 (first published: 2017-03-22)
6,763 reads
Blogs
How I Built RAG for My Accounting App on Bedrock and pgvector
The first version of my accounting assistant could not find a single purchase of...
Why AI isn’t paying off yet, and what to invest in first
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
Flyway Tips: Analytics Platforms (Snowflake and Databricks)
By Steve Jones
I’m really excited about some growth in Flyway support. I’ve been asking about this...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Slow - Linked server query
Hi I have this slow query that is pulling data from a linked server....
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers