Rotating TDE Certificates without re-encrypting data
I talked previously about why we have each of the layers in the encryption hierarchy used to support TDE (Transparent...
2018-04-04 (first published: 2018-03-28)
3,508 reads
What’s the difference between Files and Filegroups?
tl;dr; Filegroups are a logical construct used to separate tables and indexes from each other, files are the physical construct...
2018-03-28
795 reads
SQLSaturday Orlando 2018 – Planned for October 6
Just a quick note that we’ve reserved the date for our 12th SQLSaturday here in Orlando. It will be held...
2018-03-28
297 reads
SQLSaturday Tools
Much has been said about SQL Saturday tools and how PASS is pulling back from development of those tools past...
2018-04-06 (first published: 2018-03-27)
2,667 reads
Power BI Custom Visuals Class (Module 96 – Enlighten Waffle Chart)
In this module you will learn how to use the Enlighten Waffle Chart. The Enlighten Waffle Chart is a simple...
2018-04-03 (first published: 2018-03-27)
2,558 reads
Women in Technology - All are welcome!
I was at SQL Saturday 723 in Rochester, NY last weekend. I was selected to deliver 2 sessions, and I...
2018-03-27
231 reads
Database Has Been Paused
I was looking forward to do some work with Azure SQL Data Warehouse (DWH) when I hit the new query...
2018-04-03 (first published: 2018-03-27)
3,475 reads
Getting Things Done With SSMS
As a SQL Server pro, I spend most of my productive time in the SQL Server Management Studio (SSMS). I...
2018-04-04 (first published: 2018-03-27)
2,974 reads
AT TIME ZONE: The easy way to deal with time zones and daylight savings time
Many people think daylight savings time was created to help align the hours that the sun is up with our...
2018-04-02 (first published: 2018-03-27)
5,219 reads
AT TIME ZONE: The easy way to deal with time zones and daylight savings time
Watch this week's video on YouTube
Many people think daylight savings time was created to help align the hours that the sun is up with our waking hours so farmers...
2018-03-27
40 reads
Blogs
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
T-SQLTuesday 204: Are blogs still relevant?
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Alamat Telp BCA KCP Jatiwangi Hub/Wa. 0817-819-444
Jl. Jend. A. Yani No.224, Jatiwangi, Kec. Jatiwangi, Kabupaten Majalengka, Jawa Barat 45454
Alamat BCA KCP Rengasdengklok Hub/Wa. 0817-819-444
Jl. Raya R.Dengklok No.27, RT.049/RW.011, R.Dengklok Sel., Kec. R.Dengklok, Karawang, Jawa Barat 41352
Question of the Day
Switching Schemas I
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers