Search SSWUG.ORG:

Latest Video Programs

SSWUGtv: Steve and Embarcadero\'s Ron Huizenga discuss data modeling for the DBA

SSWUGtv: Steve and Embarcadero\'s Ron Huizenga discuss data modeling for the DBA

SSWUGtv: Steve and Embarcadero\'s Ron Huizenga discuss agile data modeling   SSWUGtv: How do you optimize your career for learning or responsibility?   SSWUGtv: Steve and Embarcadero\'s Ron Huizenga discuss data architecture challenges.  
 

From the Editor's Desk...

DejaVu  -  Here we go again. We don't need to learn how to write code anymore. Now we will simply provide the scaffolding between different frameworks. Is it really true this time? It hasn't panned out for the last 30 years of promises.

DBA Quick Tips  -  Today I'm providing a couple quick tips for Microsoft SQL Server that have been helpful. One helps you locate and kill all connections to a specific database. The other provides a quick count of the number of rows in a table, regardless of the table size.

Compliance Auditing  -  In today's world we often have to audit database activity. Simple audits track who modified a record. Complicated audits track modifications to column, and require history on what data a user has accessed. How do you implement and prove compliance for data auditing?

Free virtual conference...in just days now  -  The SSWUG.org virtual conference, with more than 30 sessions across 3 tracks in 2 days is this week. We're excited - and it's all free to attend! (see www.sswugvc.com)

Big Data Acquisition and Retention  -  How do you determine when to import data into your warehouse, and how long to keep it? The key is statistical relevance. Today I try to clarify the concept a little better.

Statistically Relevant  -  One of the biggest problems when creating a data warehouse is determining what to put in it. Second to that question is, how often do I need to update my warehouse? What do you think; real time, hourly, daily, weekly, monthly?

No SQL Utilization  -  What is the total capacity of your NoSQL solution? What is your current allocation? When are you going to need to increase your capacity? Some of these numbers are easy to get. Others take more effort. In trying to control costs I found it difficult to predict the future simply using tools built into NoSQL.

Cloud Use Changing - Bursting?  -  IBM's Paul Zikopoulos is talking about the cloud as a hybrid, mixed environment is changing. Specifically, how you split up workloads and attack things is changing. What do you think?

Did you know? We have more than 30 free sessions online in days!  -  Security, big data, performance, administration sessions and so much more, but the time to register is NOW.


Community Content - News, Articles, How-To Information and More from Around the World