DBCC Just Runs Faster, Unless You’re Cheap
The CSS SQL Server Engineers have released a post showing that consistency checks using DBCC CHECKDB is faster and scales...
2016-02-25
611 reads
Well that’s just neat: Row Level Security, new in SQL Server 2016
SQL Server 2016 offers Row Level Security, which sounds awfully cool. It’s apparently been available in Azure for a while,...
2016-02-25
1,123 reads
SQL Filegroup/File Proportional Fill Algorithm
[read this post on Mr. Fox SQL blog] I had a question at work recently where there was some confusion around how SQL Server allocates data across data files within a filegroup...
2016-02-24
21 reads
SQL Filegroup/File Proportional Fill Algorithm
[read this post on Mr. Fox SQL blog]
I had a question at work recently where there was some confusion around how SQL...
2016-03-02 (first published: 2016-02-24)
2,702 reads
Grabbing Fitbit Data
Recently the T-SQL Tuesday topic was Power BI. A cool topic, and an interesting application.
I saw Rob Farley build a...
2016-02-24
1,331 reads
SQL – List Server and DB Permsission
Database Level Permission
DECLARE@DBuser_sql VARCHAR(4000)DECLARE@DBuser_table TABLE(
DBName VARCHAR(200),
UserName VARCHAR(250),
LoginType VARCHAR(500),
AssociatedDatabaseRole VARCHAR(200))SET@DBuser_sql='
SELECT "[?]" AS DBName,a.name AS Name,
a.type_desc AS LoginType,
USER_NAME(b.role_principal_id) AS AssociatedDatabaseRole
FROM [?].sys.database_principals a
LEFT OUTER...
2016-02-24
639 reads
HP Superdome X for high-end OLTP/DW
No, Superdome X is not the name of the stadium where they played in the last Super Bowl. Rather, Superdome...
2016-02-25 (first published: 2016-02-24)
1,295 reads
Query Store and Recompile
One of the many advantages of SQL Cruise is the ability to have enough time during a presentation to be...
2016-02-24
632 reads
Powershell script to create multiple SQL Server Connections
As with most of these types of things, I had a need. I want to show how using sys.dm_exec_[requests/sessions/connections] is...
2016-02-24
1,079 reads
TSQL Tuesday #75 Round Up Redux
Okay so I already posted a round up post for this month. You can see it here. Tonight one of the participants, Rob Farley (Blog | Twitter) made me...
2016-02-24
28 reads
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
Telp BCA KCP Kemang Pratama Cs 0823-7497-7784
Wa:082374977784 Komplek, Ruko Kemang Pratama, Jl. Kemang Pratama Raya No.1A Blk AN, RT.004/RW.001, Bojong...
What Did Healthy Look Like?
Comments posted to this topic are about the item What Did Healthy Look Like?
Alamat BCA KCP Modernland Telp:0821°7555°651
Telp/Wa 628217555651 Ruko Modern Walk, Jl. Hartono Raya No.063 MW No. 062, RT.001/RW.006, Klp....
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers